Forum Discussion
Getting the full year of data
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...
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)
FotFly
Helper II
Helper IIYou 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)