Get last date on next year February

[akshaysmath]

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 date, which is 28-02-2023. I'm trying to get it with the below DAX command but the value is populating "Blank" when I pull it in a card.

Financial Year End =

    var get_current_Year = STARTOFYEAR(ENDOFYEAR('YTD data'[part_date_3]))

    var get_feb_last_date = DATEADD(DATEADD(DATEADD(get_current_Year , 2, MONTH),-1,DAY),1,YEAR)

    return get_feb_last_date

Appreciate the help.

[Anonymous · Accepted solution]

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

[Anonymous]

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)

[akshaysmath]

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?