Forum Discussion

Sidd_Kaush's avatar
Sidd_Kaush
Frequent Visitor
3 years ago
Solved

Cumulative Total for Coming Two Months

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 the...
Need Help
  • vk_pbi's avatar
    vk_pbi
    3 years ago

    Hi Sidd_Kaush 

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

     

     

  • Sidd_Kaush's avatar
    Sidd_Kaush
    3 years ago

    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)
vk_pbi's avatar
vk_pbi
Icon for Resolver II rankResolver II
3 years ago

Hi,

Hopefully, the below dax will works

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