Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi, I'm trying to add two conditions using the custom column format, however keep getting an error under "and".
Thanks for your reply. I re-wrote it all again but then the error was at the end of the sentence. However, I checked on google and apparently where theres an "if" there must be a "then" and an "else" so I added "else null" and now it seems to have worked.
Hi @DianaDSTM
Use double quotes like this, not the fancy curly ones in your image
if [Condition 1] = "OK" and [Condition 2] = "OK" then "OK To Pay" .......
regards
Phil
Proud to be a Super User!