Forum Discussion

Anonymus_18's avatar
Anonymus_18
Frequent Visitor
2 years ago
Solved

Latest DATA

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

DateVERSIONLATEST
13-12-2023FIRST 
13-12-2023SECOND 
13-12-2023FINALYES
12-12-2023FIRST 
12-12-2023SECONDYES
11-12-2023FIRSTYES
Need Help
  • Fowmy's avatar
    Fowmy
    2 years ago

    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

     

     

     



1 Reply

  • Fowmy's avatar
    Fowmy
    Super User
    2 years ago

    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