Getting the maximum date from rows

[jhauw74]

Hi - I am stuck on how I can get the max date based on the rows in a table :

I'd like to be able to identify that max date row as 1 and the rest as 0.

Beent trying using earlier but doesn't seems to work - any help greatly appreciated.

[jhauw74]

Thank you @Ashish_Mathur the formula works 😀

[Ashish_Mathur]

You are welcome.

[Ashish_Mathur · Accepted solution]

Hi,

Write this calculated column formula

Flag of max date = 1*(Data[Effective Date]=calculate(max(Effective date),filter(Data,Data[Employee ID]=earlier(Data[Employee ID])))

Hope this helps.

[Ahmedx]

pls show expected output