Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have to create a line chart with the measure of difference between the values of two months in rolling window with 12 month gap. Basically:
For Aug-23, I have to take a difference between value of Aug-23 and Sep-22
For Sep-23, difference between value of Oct-22 and Sep-23 and likewise.
Try this
SUM({<MonthYear = {"=$(=Date(AddMonths(Max(MonthStart(MonthYear)), 0), 'MMM-YY'))"}>} Sales)
-
SUM({<MonthYear = {"=$(=Date(AddMonths(Max(MonthStart(MonthYear)), -12), 'MMM-YY'))"}>} Sales)