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)
Sidd_Kaush's avatar
Sidd_Kaush
Frequent Visitor
3 years ago

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

  • vk_pbi's avatar
    vk_pbi
    Icon for Resolver II rankResolver II
    3 years ago

    Hi Sidd_Kaush 

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