06-27-2017 07:31 AM
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.
Solved! Go to Solution.
06-28-2017 05:49 AM
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?