Urgent! Need help!!

[ryan_mayu]

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.

[PattemManohar]

@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])

[ryan_mayu]

@PattemManohar,

thanks for your help. Is it possible to create a measure to draw a chart by month?

[PattemManohar · Accepted solution]

@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 ))

[ryan_mayu]

@PattemManohar,

Can I escalate this question?

I read your DAX, it works in a year. What about Jan 2019= Nov 2018+Dec 2018+Jan 2019?

Do you have any idea on how to solve this problem?

[PattemManohar]

@ryan_mayu Yes, Ofcourse !! In that case, try the same DAX by removing the YEAR condition in the FILTER.

[ryan_mayu]

@PattemManohar, I will try that. Thanks a lot.

[ryan_mayu]

Thanks, it works.