Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
Can anyone tell me why the State column from line 2 onwards are not green please? (Today's date is the 26th Feb 2021)
Solved! Go to Solution.
SWITCH returns the first result that matches, so it never gets to the Green condition (since if it satisfies the Green condition it necessarily satisfies the Yellow condition first).
Try swapping the Yellow and Green lines to put the more restrictive condition first.
SWITCH returns the first result that matches, so it never gets to the Green condition (since if it satisfies the Green condition it necessarily satisfies the Yellow condition first).
Try swapping the Yellow and Green lines to put the more restrictive condition first.
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |