Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
Solved! Go to 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
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@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
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
User | Count |
---|---|
98 | |
91 | |
84 | |
72 | |
67 |
User | Count |
---|---|
114 | |
103 | |
100 | |
72 | |
64 |