Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Narasimha
Helper I
Helper I

DAX help on Last3 months

Hi Team,

 

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

 

3monthsDAX.PNG

 

Thnaks

Narasimha Reddy

 

 

1 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

View solution in original post

4 REPLIES 4
DoubleJ
Solution Supplier
Solution Supplier

How about

 

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

 

Hope this helps!

JJ

Thanks for quick response..

 With your DAX formula, Am getting below results.

 

3monthsDAX1.PNG

 

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

 

 

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

Thanks @DoubleJ, Its working fine.

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.