Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Team,
I have a requirement to create Week Over Week Report.
The data is at Weekly Snapshot grain.
So every friday snapshot is taken.
So lets say for 16th Feb 2018, the number of records in Fact is 20
and for 23rd Feb, the number of records in fact is 25
So my WoW metric should show me 5 when I run a report for 23rd Feb.
I need the flexibility to change the week from the slicer, so whichever value I select depending on that it should compare it previous week and show me the WoW change.
Regards,
Akash
Just try to add a measure.
https://www.sqlbi.com/articles/compare-equivalent-periods-in-dax/
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |