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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.