Show the last day the current year

[Portrek]

Hello everyone, I have a question.

I have a formula that one of the parameters is the last day of the current year and I still haven't managed to have that date updated automatically at the turn of the year.

Ask: How can I show though a measure the last day of the current year, in the case of that year 12/31/2021 and automatically in 01/01/2022 the measure brings me the date of 12/31/2022 ?

Thanks for your help !!

[mahoneypat]

If you need it in the query editor, here is the M equivalent

= #date(Date.Year(DateTime.LocalNow()),12,31)

Regards,

Pat

[d_gosbell · Accepted solution]

And expression like the following should do what you are asking for:

DATE( YEAR(TODAY()),12,31)