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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

Previous month issue

Hello, 

 

I need to extract previous month for today. 

I tried previousmonth= date(year(today ()),month(today) - 1,day(today()))

But it displays 02/03/2021 which is wrong, how to correct it please? 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@Anonymous , because there is no 30th in feb , Try a measure like

 

previousmonth = Var _1 = date(year(today ()),month(today()) - 1,day(today())) Return if(EOMONTH(today(),-1) < _1, EOMONTH(today(),-1) , _1)

View solution in original post

1 REPLY 1
amitchandak
Super User
Super User

@Anonymous , because there is no 30th in feb , Try a measure like

 

previousmonth = Var _1 = date(year(today ()),month(today()) - 1,day(today())) Return if(EOMONTH(today(),-1) < _1, EOMONTH(today(),-1) , _1)

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors