Week Over Week Comparison Of Full Report

[krichmond]

We have a published Power BI report that refreshes from AWS every 3 hours. However, we have a reporting requirement where we have to do a week-over-week comparison of the data within that report and identify variances (either up or down). Is there a way to do this within Power BI? Or would we need to solution for that on the AWS side of things?

[amitchandak · Accepted solution]

@krichmond , You can refer my blogs on that. Refer Rank Approch

Time Intelligence, DATESMTD, DATESQTD, DATESYTD, Week On Week, Week Till Date, Custom Period on Period,
Custom Period till date: https://youtu.be/aU2aKbnHuWs&t=145s

Power BI — Week on Week and WTD
https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3
https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-La...
https://www.youtube.com/watch?v=pnAesWxYgJ8