Sales for the last 5 months

[sw123]

Hi,

Can you tell me what is wrong with this measure? I want the table to show sales for the last 5 months from today:

Sales Period = CALCULATE(

SUM(F_Invoice[Sales]);

DATESINPERIOD(F_Invoice[Invoicedate];

LASTDATE(F_Invoice[Invoicedate]);

-5;MONTH))

[harshnathani · Accepted solution]

Hi @sw123 ,

You can try

CALCULATE(SUM(F_Invoice[Sales]),DATESBETWEEN(F_Invoice[Invoicedate],EDATE(EOMONTH(TODAY(),-1)+1,-5),EOMONTH(TODAY(),-1)+1))

or 

Try using MAX instead of LASTDATE

Sales Period = CALCULATE(

SUM(F_Invoice[Sales]);

DATESINPERIOD(F_Invoice[Invoicedate];

MAX(F_Invoice[Invoicedate]);

-5;MONTH))

You can also see the below blog

http://sqljason.com/2018/03/display-last-n-months-selected-month-using-single-date-dimension-in-powe...

Regards,

Harsh Nathani

[sw123]

Thanx, still not working, though 😞

[sw123]

Now I read you blog more carefully and used the last updated simpler formula and it worked! Great thanx!

[stevedep]

You can try:

Sales Period = CALCULATE(
SUM(F_Invoice[Sales]);all(F_Invoice[Invoicedate]);
DATESINPERIOD(F_Invoice[Invoicedate];
LASTDATE(F_Invoice[Invoicedate]);
-5;MONTH))

[sw123]

Thanx, but it is still not working as it should 😞