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. Date VERSION LATEST 13-12-2023 FIRST   13-12-2023 SECOND   13-12-2023 FINAL YES 12-12-2023 FIRST   12-12-2023...
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

     

     

     



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