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, I am trying a relatively simple if then in a new Conditional Column.
The results are clearly incorrect and I cannot figure out why.
All of the results show "In Progress" while some of the results should be showing "Completed".
if [Completed but late] = "Completed but late" and [Completed in time] = "Completed in time" and [Issues] = "null" and [Not Started] = "null" then "Completed" else "In Progress")
Solved! Go to Solution.
Hi @Anonymous ,
you can do like
if ([Completed but late] <> null
or [Completed in time] <> null )
and [Issues] = null
and [Not Started] = null
then "Completed"
else
"In Progress"
Hope this helps
Hi @Anonymous ,
you can do like
if ([Completed but late] <> null
or [Completed in time] <> null )
and [Issues] = null
and [Not Started] = null
then "Completed"
else
"In Progress"
Hope this helps
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.