Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi there,
I need to form the correct version of this IF statement. Or, more likely, a different statement with the same outcome!
If Status = 3 then "Won"
If Status = 4 then "Lost"
If Status = BLANK then "Open"
Below is the code I'm trying and the Blank part does not seem to recognise it should display as "Open".
Any help appreciated,
Thanks
Status = (IF(opportunities[statuscode] = 3, "Won", IF(opportunities[statuscode] = 4, "Lost", IF(opportunities[statuscode] = BLANK(), "Open"))))
Solved! Go to Solution.
You could try
Status = SWITCH ( opportunities[statuscode], 3, "Won", 4, "Lost", BLANK (), "Open", "defaut value if doesn't in any prior case" )
You could try
Status = SWITCH ( opportunities[statuscode], 3, "Won", 4, "Lost", BLANK (), "Open", "defaut value if doesn't in any prior case" )