End of Previous Month Date manipulation

[jh292]

Hi,

Does anyone have a way of inspecting a date and if it's the end of a month, returning that. if it isn't then returning end of the previous month? 

i.e.;

15/1/2020 returns 31/12/2019

but

30/9/2020 returns 30/9/2020

Thanks for the help

[amitchandak · Accepted solution]

@jh292 ,  Try like

eomonth([date],-1)

or

eomonth(max(Date[date]),-1)

[jh292]

Thanks, had to add a yes/no to if it was already the end of the month then another to select which date based on that yes/no - but got there in the end! It ain't pretty, but it will do!