Previous month with TREATAS function

Question

Hello Experts,I need some help with this measure.I need to get the previous month's sales using this function.Actual = CALCULATE([Sales], TREATAS(SUMMARIZE(FactSalesForecast,FactSalesForecast[Year SF],FactSalesForecast[Month SF]),DimDate[Year],DimDate[Month]))Please help...Thanks,&nbsp;P

mahesh0016 · Answer

Puja&nbsp;please try thisActual = CALCULATE (&nbsp; &nbsp; [Sales],&nbsp; &nbsp; TREATAS (&nbsp; &nbsp; &nbsp; &nbsp; // SUMMARIZE (&nbsp; &nbsp; &nbsp; &nbsp; // &nbsp; &nbsp; FactSalesForecast,&nbsp; &nbsp; &nbsp; &nbsp; // &nbsp; &nbsp; FactSalesForecast[Year SF],&nbsp; &nbsp; &nbsp; &nbsp; // &nbsp; &nbsp; FactSalesForecast[Month SF]&nbsp; &nbsp; &nbsp; &nbsp; // ),&nbsp; &nbsp; &nbsp; &nbsp; VALUES(FactSalesForecast[Month SF]),&nbsp; &nbsp; &nbsp; &nbsp; DimDate[Month]&nbsp; &nbsp; ))

puja · Answer

Mahesh0016&nbsp;, How this code is going to get the previous month's data? could you please explain?&nbsp;&nbsp;&nbsp;

mahesh0016 · Answer

Puja&nbsp;please Can you first tell me code working or not.Thank you.

Forum Discussion

Previous month with TREATAS function

3 Replies

Related content

The TREATAS Function

Using TREATAS DAX function in calculated columns

TREATAS

TREATAS in DAX

Combine TREATAS with Calculate function