Hi Team, I have been working on a report where I want to display cumulative total of last 3 months

[pradeepnani]

Cumulative total of last 3 months along with the previous added values

Hi Team,

I have been working on a report where I want to display the cumulative total of last 3 months along with the previous months added values 

[bhanu_gautam · Accepted solution]

@pradeepnani Try using

VAR LastSDate = MAX('CALENDAR'[Date])
VAR Last3Months = DATESINPERIOD('CALENDAR'[Date], LastSDate, -3, MONTH)
VAR Last3MonthsSum = CALCULATE(SUM(Orders[Freight]), Last3Months)
VAR Month1 = CALCULATE(SUM(Orders[Freight]), DATESINPERIOD('CALENDAR'[Date], LastSDate, -1, MONTH))
VAR Month2 = CALCULATE(SUM(Orders[Freight]), DATESINPERIOD('CALENDAR'[Date], EDATE(LastSDate, -1), -1, MONTH))
VAR Month3 = CALCULATE(SUM(Orders[Freight]), DATESINPERIOD('CALENDAR'[Date], EDATE(LastSDate, -2), -1, MONTH))

RETURN IF(
ISBLANK(SELECTEDVALUE('CALENDAR'[MONTH_YEAR])),
0,
FORMAT(Last3MonthsSum, "#,##0") & " (" & FORMAT(Month1, "#,##0") & ") + (" & FORMAT(Month2, "#,##0") & ") + (" & FORMAT(Month3, "#,##0") & ")"
)

[pradeepnani]

sorry, for inconvenience here's the code 

**bleep** =

VAR LastSDate = MAX('CALENDAR'[Date])

VAR Last3MonthsSum = CALCULATE(SUM(Orders[Freight]), DATESINPERIOD('CALENDAR'[Date], LastSDate, -3, MONTH))

VAR Month1 = CALCULATE(SUM(Orders[Freight]), DATESINPERIOD('CALENDAR'[Date], LastSDate, -1, MONTH))

VAR Month2 = CALCULATE(SUM(Orders[Freight]), DATESINPERIOD('CALENDAR'[Date], EDATE(LastSDate, -1), -1, MONTH))

VAR Month3 = CALCULATE(SUM(Orders[Freight]), DATESINPERIOD('CALENDAR'[Date], EDATE(LastSDate, -2), -1, MONTH))

RETURN IF(

    ISBLANK(SELECTEDVALUE('CALENDAR'[MONTH_YEAR])),

    0,

      Last3MonthsSum & " (" & Month1 & ") + (" & Month2 & ") + (" & Month3 & ")"

)

[bhanu_gautam]

@pradeepnani ,It would be better if instead of snap you share code with which we can work.