last day February on leap year.

[MiguelSaldana77]

Hi everybody, I have a problem Calculating February last day on leap year.
Suppose we are on February 15, 2017 and I need to calculate the last day of the same date one year back (February 29,2016) (It’s a Leap year).
Any idea?

[MiguelSaldana77 · Accepted solution]

I finally made this way

[amitchandak]

@MiguelSaldana77 ,

If it is a continuous date

the dateadd(Table[Date],-1,year)

Or

Last year same date = date(year(Table[Date])-1,month(Table[Date]),day(Table[Date]))

[az38]

@MiguelSaldana77 

if you need last day of the same month, but in a previous year try

Column = ENDOFMONTH( DATE(YEAR([Date]) - 1, MONTH([Date]), DAY([Date])) )

[MiguelSaldana77]

The Problem is because the dashboard has 2 filters (Year  and Month )  and In order to get the date I´m using MAX(Time(Date))  and the "ENDOFMONTH"  not accept Max as a part of the formula.
Error=    

ENDOFMONTH( DATE( VALUE(YEAR(MAX('Cat Tiempo'[Fecha])))- 1, MONTH(Max('Cat Tiempo'[Fecha])), DAY(Max('Cat Tiempo'[Fecha]))) )

[Greg_Deckler]

@MiguelSaldana77 - EOMONTH(MAX('Cat Tiempo'[Fecha]),-12) For last year February. For this year Feb, EOMONTH(MAX('Cat Tiempo'[Fecha]),0) assuming your max date is some date in Feb.