Forum Discussion

ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper User
7 years ago
Solved

Urgent! Need help!!

Hi , i have a sample data below.

 

How can I use DAX to get the below result?

I want to get the total sales in of pervious three months.

Jan=Jan,

Feb=Jan+Feb

Mar=Jan+Feb+Mar

....

Sep=Jul+Aug+Sep

 

 

 

Thanks in advanced.

 

Need Help
  • PattemManohar's avatar
    PattemManohar
    7 years ago

    ryan_mayu Here is the measure for same...

     

    Test46Out = 
CALCULATE(SUM(Test46CummSum[Value]),FILTER(ALL(Test46CummSum),Test46CummSum[Date] <= MAX(Test46CummSum[Date]) && YEAR(Test46CummSum[Date]) = YEAR(MAX(Test46CummSum[Date])) && DATEDIFF(Test46CummSum[Date],MAX(Test46CummSum[Date]),MONTH)<=2 ))

7 Replies

  • PattemManohar's avatar
    PattemManohar
    Icon for Community Champion rankCommunity Champion
    7 years ago

    ryan_mayu Please try this as a "New Table"

     

    Test46Out = 
VAR _Temp = ADDCOLUMNS(Test46CummSum,"CummSum",CALCULATE(SUM(Test46CummSum[Value]),FILTER(Test46CummSum,Test46CummSum[Date]<=EARLIER(Test46CummSum[Date]) && DATEDIFF(Test46CummSum[Date],EARLIER(Test46CummSum[Date]),MONTH)<=2 )))
RETURN SELECTCOLUMNS(_Temp,"Month",[Month],"Total",[CummSum])

      • PattemManohar's avatar
        PattemManohar
        Icon for Community Champion rankCommunity Champion
        7 years ago

        ryan_mayu Here is the measure for same...

         

        Test46Out = 
CALCULATE(SUM(Test46CummSum[Value]),FILTER(ALL(Test46CummSum),Test46CummSum[Date] <= MAX(Test46CummSum[Date]) && YEAR(Test46CummSum[Date]) = YEAR(MAX(Test46CummSum[Date])) && DATEDIFF(Test46CummSum[Date],MAX(Test46CummSum[Date]),MONTH)<=2 ))