
Contributor
2024-09-11
03:34 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Difference between the values of two months in rolling window.
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.
1 Reply

MVP
2025-01-23
12:01 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try this
SUM({<MonthYear = {"=$(=Date(AddMonths(Max(MonthStart(MonthYear)), 0), 'MMM-YY'))"}>} Sales)
-
SUM({<MonthYear = {"=$(=Date(AddMonths(Max(MonthStart(MonthYear)), -12), 'MMM-YY'))"}>} Sales)
122 Views
