DAX help on Last3 months

[Narasimha]

Hi Team,

I have created visual for last 3 months data using below dax. here i want to exclude current month data.

Thnaks

Narasimha Reddy

[DoubleJ]

How about

3Months = IF(Data[Date] >= EOMONTH(TODAY();-4) && Data[Date] < EOMONTH(TODAY();-1);
    TRUE();
    FALSE())

Hope this helps!

JJ

[Narasimha]

Thanks for quick response..

 With your DAX formula, Am getting below results.

In the above Visual, I am getting extra month i/e Mar'2017 data as well. I need to exclude Mar'2017 data.

Thanks

Narasimha Reddy

[DoubleJ · Accepted solution]

sorry, my mistake!

Replace ">=" with ">". The equal sign is not needed as it returns TRUE() on the last day of the month in March. Formula then is:

3Months = IF(Data[Date] > EOMONTH(TODAY();-4) && Data[Date] < EOMONTH(TODAY();-1);
    TRUE();
    FALSE())

Greetings

JJ

[Narasimha]

Thanks @DoubleJ, Its working fine.