Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Calculated Column with MAX Date

Hi, I have this calculated column called "Ready for Prep":     I need to improve it by making the IF take into account, for each KEY, the MAX date in the column "Change Date". In the example,...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    Anonymous , Try like

    If([change date]= maxx(filter(Epicstatuschangelog, [key]=earlier([Key]) && [to] ="Ready for development"),[change date]) && [to] ="Ready for development",
1,0)
amitchandak's avatar
amitchandak
Super User
6 years ago

Anonymous , Try like

If([change date]= maxx(filter(Epicstatuschangelog, [key]=earlier([Key]) && [to] ="Ready for development"),[change date]) && [to] ="Ready for development",
1,0)
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago
    Thanks !!