Forum Discussion
Solved
Cumulative Measures Using Monthly Buckets.
Hello, I am trying to create a visual that shows a cumulative forecast variance throughout the year. I'd like to show the cumulative absolute value of the forecast v actual variance by month. I...
kvonck34 , Do not use abs in
R&A Absolute Delta = sum('Import - RA Financials'[Actual Value])-sum('Import - RA Financials'[Forecast Value])
if needed used it in Cum_Absolute Value
Cum_Absolute Value =
abs(SUMX (
FILTER (
ALLSELECTED ('Import - RA Financials'),
'Import - RA Financials'[R&A Period Date]<=max('Import - RA Financials'[R&A Period Date])
),
[R&A Absolute Delta]
))
I made the changes you mentioned, but it the abs doesn't seem to be working. The cumulation of values now works, which is great, but i'm just seeing negative values for the delta.
| R&A Period Date | Forecast Value | Actual Value | R&A Absolute Delta | Cum_Absolute Value |
| 1/1/2020 0:00 | 3,091,234 | 1,591,230 | (1,500,004) | (1,500,004) |
| 2/1/2020 0:00 | 3,640,461 | 2,852,832 | (787,629) | (2,287,633) |
| 3/1/2020 0:00 | 2,526,878 | 1,108,853 | (1,418,025) | (3,705,658) |
| 4/1/2020 0:00 | 1,633,300 | 1,416,034 | (217,266) | (3,922,924) |
| 5/1/2020 0:00 | 1,059,937 | 885,944 | (173,993) | (4,096,917) |
| 6/1/2020 0:00 | 996,816 | 922,700 | (74,116) | (4,171,033) |
| 7/1/2020 0:00 | 3,416,619 | 2,794,734 | (621,885) | (4,792,918) |
| 8/1/2020 0:00 | 3,299,384 | 2,047,704 | (1,251,680) | (6,044,598) |
| 9/1/2020 0:00 | 3,662,643 | 93 | (3,662,550) | (9,707,148) |
| 10/1/2020 0:00 | 3,420,711 | 85 | (3,420,626) | (13,127,774) |
| 11/1/2020 0:00 | 2,948,893 | 61 | (2,948,832) | (16,076,606) |
| 12/1/2020 0:00 | 2,265,416 | 51 | (2,265,365) | (18,341,971) |
Also, is there a way within the formula to only track the cumulative delta on days prior to today?