Forum Discussion
Comparing values to previous months
Please see the attached sample file. You would not need to create a measure for every month; just for the relative month.
In order to have all of this shown on one table, you will need to either create measures for all of the values to be included in the table or create a calculated table that produces the desired results and then add all to the visual. Calculations should be dynamic so you won't have to update them for specific dates, like CurrentValue-1Mo, CurrentValue-2Mo, CurrentValue-3Mo, ChangeVs12Mo, ChangeVs6Mo, etc.
Please let me know if I can further assist.
Just to confirm, do you mean i would need to create measures for each month, Apr, May, Jun etc as well as diff to Apr, diff to previous months, 6 months and 12 months?
Are you able to give me an example?
kind regards
Hetal
Please see the attached sample file. You would not need to create a measure for every month; just for the relative month.
Thank you very much for this.