Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
title says it all. I am looking ot perform a month over month change measure, and the quick measure calc only works when I break out the date by the hierarchy. how can i make it work with just the month start date?
As long as you are filtered to a year in your report (assuming you want to see the MoM% for one year, not all the years combined), you can go ahead and just pop the month field into your visual. You don't need the whole hierarchy.
Below is from the adventure_works dataset - I am filtered to FY2020, and just have the month numbers in the visual.
Proud to be a Super User! | |
User | Count |
---|---|
77 | |
77 | |
68 | |
67 | |
49 |
User | Count |
---|---|
108 | |
104 | |
93 | |
83 | |
64 |