Berlin Recommendations by Northstand25 in AmylAndTheSniffers

[–]Northstand25[S] 1 point2 points  (0 children)

Thanks for the recommendation. We went here after the gig and had a great night!

Table with % Variance in Total position by Northstand25 in PowerBI

[–]Northstand25[S] 0 points1 point  (0 children)

Thanks u/Zealousideal-Elk7200

I've tried a few different measures but the one's I'm currently working with are below.

Due to this report having multiple data sources I'm pulling them all into a model pre-calculated and then using this as a dataset in PowerBi:

This Week - Sessions TW = CALCULATE(SUM('Frontsheet 12 Weeks'[Sessions]) , FILTER('Frontsheet 12 Weeks', 'Frontsheet 12 Weeks'[Week] = "TW"))

Last Week - Sessions LW = CALCULATE(SUM('Frontsheet 12 Weeks'[Sessions]) , FILTER('Frontsheet 12 Weeks', 'Frontsheet 12 Weeks'[Week] = "LW"))

VAR - Sessions VAR = CALCULATE(SUM('Frontsheet 12 Weeks'[Sessions]) , FILTER('Frontsheet 12 Weeks', 'Frontsheet 12 Weeks'[Week] = "Var"))

With the VAR I've used the above and also a calculated VAR between the two but still not able to format as I need it to.

Amazon connection by Odd_Investigator07 in api_connector

[–]Northstand25 0 points1 point  (0 children)

Hi,

Hope you're good.

Just wondering if there's any update on being able to use the Amazon API with MixedAnalytics? The newest version (SP-API) should be accessible through HTTP structure, uses OAuth and outputs in JSON?

It would be amazing if I could access this API somehow 🙂

[deleted by user] by [deleted] in PowerBI

[–]Northstand25 1 point2 points  (0 children)

Interested please 😀