Quck Calculation MOM and YOY % not calculating correctly.

[AKF75]

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.

[v-sihou-msft]

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