topic Re: Sum Last 3 months excluding the current month in DAX Commands and Tips

Sum Last 3 months excluding the current month

Hvaldes — Tue, 16 Jun 2020 02:26:05 GMT

Hello Community

I'm not expert in Power BI and I would like to ask your support regarding a measure of time intelligence in Power Bi

I need to get the sum of last 3 monts but excluding the current month.

Please find the sentence.

Last_3_Months = CALCULATE(SUM('Facturación MRS'[Ventas]),DATESINPERIOD('Facturación MRS'[DocDueDate],LASTDATE('Facturación MRS'[DocDueDate]),-3,MONTH))

What are I doing wrong?

'Facturación MRS'[Ventas]) : Column where I show the sales

Facturación MRS'[DocDueDate]: column where it show the full date in Sales Table.

I tried to find any solution but I couldn't find.

I'll appreciate your support

Thanks and I look forward to your comments.

Re: Sum Last 3 months excluding the current month

Anonymous — Tue, 16 Jun 2020 05:55:57 GMT

l think this should work:

CALCULATE(SUMX('Facturación MRS',IF(DATEDIFF('Facturación MRS'[DocDueDate],TODAY(),MONTH) <= 3 && DATEDIFF('Facturación MRS'[DocDueDate],TODAY(),MONTH) >= 1,'Facturación MRS'[Ventas],0)))

Re: Sum Last 3 months excluding the current month

Hvaldes — Tue, 16 Jun 2020 13:09:45 GMT

Thanks Chris for your support!

It does work!

Many thanks