Getting the full year of data

[U156531]

This formula If( MAX(YourTable[YourDateColumn]) <= EDATE(TODAY(), -60), 1, 0 ) takes me back to 2019 but It excludes some of the months from 2019. How can I change this formula to go back 5 years and get the full year of 2019?

Thanks

[FotFly · Accepted solution]

You forgot to add the arguments for when the condition is true or the condition is false. Like this

IF(MAX(tblSTD_MASTER[ISSUEDATE]) <=DATE(YEAR(TODAY9()),1,1), 1, 0)

[U156531]

I don't seem to be able to get the syntax correct?

[FotFly]

Hi,

Why don't you change the EDATE... part with DATE(YEAR(TODAY())-5,1,1). This will give you the whole year that was 5 years ago (meaning from the start of 2019)?