Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 |
---|---|
42 | |
28 | |
24 | |
20 | |
16 |
User | Count |
---|---|
54 | |
35 | |
18 | |
18 | |
15 |