Latest DATA

[Anonymus_18]

I need to create this Latest column based on the below data.

Date	VERSION	LATEST
13-12-2023	FIRST
13-12-2023	SECOND
13-12-2023	FINAL	YES
12-12-2023	FIRST
12-12-2023	SECOND	YES
11-12-2023	FIRST	YES

[Fowmy · Accepted solution]

@Anonymus_18 

Create two columns, your first column to get the sort order:

Ver Order = 
SWITCH(
    [VERSION],
    "FIRST" , 1,
    "SECOND" , 2,
    "FINAL" , 3
)

Second column for the result = 

New Col = 
Var __Order = 
    CALCULATE(
        MAX( Table02[Ver Order] ),
        ALLEXCEPT( Table02 , Table02[Date] )
    )
Var __Result = 
    IF( Table02[Ver Order] = __Order , "Yes" )
RETURN
    __Result