Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Please I would like to develop a conditional column with the following rule: If Today Vs Due Day is equal or greater than 0, the result should be "On Time", but if Today Vs Due Day is less than 0 and the Code is #Q the result should be "Observed", and if Today Vs Due Day is less than 0 and the Code is blank or other value, the result should be "Delayed". Any help. Thank you.
Solved! Go to Solution.
Column = switch ( TRUE(), T[TVDD] >= 0, "On Time", T[TVDD] < 0 && T[Code] = "#Q", "Observed", "Delayed" )
Best
D.
Column = switch ( TRUE(), T[TVDD] >= 0, "On Time", T[TVDD] < 0 && T[Code] = "#Q", "Observed", "Delayed" )
Best
D.
User | Count |
---|---|
56 | |
22 | |
19 | |
16 | |
11 |
User | Count |
---|---|
85 | |
54 | |
39 | |
21 | |
18 |