Forum Discussion
Solved
Get last date on next year February
Hey guys, Can anybody help me with the below concern? I'm looking to get the last date of next year February month. For example, if the current year is 2022, I want next year's February end d...
Try this you should have the value :
nextclosingdate=
var nextyear=year(today())+1
var datemaxmarch=date(nextyear,3,1)
return
datemaxmarch-1
but the much simple would be to create the dfate on your date table with calendar function
i
If you have a date table with dates up to end of feb 2023just do this :
nextclosingdate=
var nextyear=year(today())+1
return
calculate(max(Date[date],Date[Year]=nextyear&&Month=2)
Hi JamesFr06,
Thanks for your quick response. I don't have dates going till Feb 2023. Reason why I'm getting a blank value in the card. Is there a way where I can get the result without depending on any column?
