Solved: Previous month issue

Anonymous · ‎03-30-2021

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?

amitchandak · ‎03-30-2021

@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)

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

amitchandak · ‎03-30-2021

@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)

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Previous month issue