Forum Discussion

AKF75's avatar
AKF75
Regular Visitor
9 years ago
Solved

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 ...
Need Help
  • AKF75's avatar
    AKF75
    9 years ago

    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.

     

v-sihou-msft's avatar
v-sihou-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

AKF75

 

I haven't encountered this issue.

 

 

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

 

Can you share some sample data?

 

Regards,

AKF75's avatar
AKF75
Regular Visitor
9 years ago

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.