Cannot manipulate Date measure

[Chamalpam]

Dear PowerBI Experts,

I have below date measure

End_Date = Date (year(2023),month(01),day(31))

And below measure

New_Date = DATE(YEAR([End_Date]),MONTH(([EndDate])-5),DAY([EndDate]))

The result i want is the date to appear as 30.09.2022 however i cannot seam to get this working. Any Advise?

Please help!

[amitchandak · Accepted solution]

@Chamalpam , Try

eomonth([End Date], -5)

or

eomonth([End Date], -4)

[Chamalpam]

This works. Thank you very much @amitchandak 

[Chamalpam]

Thank you @amitchandak . It worked! I have typed it wrong the result i am looking for is 30.09.2022. 

the result i am getting is 30.09.2023

it should also work if the end_date is as below

End_Date = Date (year(2022),month(12),day(31))

result should be 31.08.2022