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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
AKF75
Regular Visitor

Quck Calculation MOM and YOY % not calculating correctly.

I am trying to use the quick calculation for MOM and YOY for a data set.  It is not calculating it correctly.  For example my January 2017 data is greater than January 2016, yet it is showing on the visual as a - %; clearly incorrect.  Does this have to do with how my date is set up in the data set?  In one column it has day, month and year? I was thinking maybe change it to just month and year? 

Any help would be appreciated.

 

 

1 ACCEPTED SOLUTION

I had to alter the calculation on the date portion.  It was -1, and I needed it to read -12. 

Now the calculation and visuals are accurate.

 

View solution in original post

2 REPLIES 2
v-sihou-msft
Microsoft Employee
Microsoft Employee

@AKF75

 

I haven't encountered this issue.

 

555.PNG

 

Since it uses DATEADD() function, make sure you have a full calendar dates in your table.

 

Can you share some sample data?

 

Regards,

I had to alter the calculation on the date portion.  It was -1, and I needed it to read -12. 

Now the calculation and visuals are accurate.

 

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

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

Top Solution Authors