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 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.

 

 

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.

     

2 Replies

  • 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.