Max Datetime flag

[M_SBS_6]

Hi, 

I have records which have a datetime field called called app_in_datetime

I'd like to create a new field which will flag the records of the latest datetime.

Example below.

app_in_datetime.         Latest_app_in

01/01/2023 12:34:45.    N

01/01/2023 13:53:34.    Y

Any idea how I would go about doing this please? 

[Ashish_Mathur]

Hi,

Assuming you have an App ID column and you want a Y or an N against each App ID, try this calculated column formula

Result = if(Data[app_in_datetime]=calculate(max(Data[app_in_datetime]),filter(Data,Data[App ID]=earlier(Data[App ID]))),"Y","N")

Hope this helps.

[amitchandak]

@M_SBS_6 , Try a new column like

if([app_in_datetime] = max(Table[app_in_datetime]) , "Y", "N" )