Cumulative Total for Coming Two Months

[Sidd_Kaush]

Currently i am looking for an solution called cumulative total in months, Lets Say If there's June Month in the row context then it should show up the sales value for July abd August, Similary If there's July then it should show up sales for August abd September. So basically its the cumulative of two months together.

@amitchandak 

[vk_pbi · Accepted solution]

Hi @Sidd_Kaush 

Its working fine, I hope you are using custom date table

[Sidd_Kaush · Accepted solution]

Its Not Working for me but i came up with below calculation and its working correct for me,

Test3 =

Var a= SELECTEDVALUE(Sheet1[Dte])

Var b=Month(a)

Var c=b+1

Var d=c+1

Var e= CALCULATE(Sheet1[Total Sales],ALL(Sheet1),FILTER('DATE','DATE'[MonthNo] in {c,d}))

Return If (e=blank(),0,e)

[Sidd_Kaush]

Hello Its not working as it retrieves the same rows within the calculation.

[vk_pbi · Accepted solution]

Hi @Sidd_Kaush 

Its working fine, I hope you are using custom date table

[vk_pbi]

Hi,

Hopefully, the below dax will works

IF(
    ISBLANK([Total Sales]),BLANK(),
CALCULATE(
    [Total Sales],
    DATESINPERIOD(
        'Date'[Date],
        MAX('Date'[Date]),
        2,MONTH
    )
)
)