Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Sut_Datanaut
Helper II
Helper II

quick measure month over month only works with date hierarchy.

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?

 

Sut_Datanaut_0-1699279976519.png

 

1 REPLY 1
audreygerred
Super User
Super User

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.

audreygerred_1-1699280395999.png

 




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.