Forum Discussion
Why does Conditional Column logic throw errors?
Hi alicek ,
Based on my testing, please try the following methods:
1.Create the sample table.
2.Select Add conditional Column and add the clause.
3.The result is shown below.
You can also view the following documents to learn more information.
Add a conditional column - Power Query | Microsoft Learn
Best Regards,
Wisdom Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
can you click on the error link and see what the message says?
Most likely its because you have null values in project stage columns, so create another line in the conditional statement after the last condition that says if the column name is null then set it to null null or Unknown or whatever value it is you need to understand that its empty. But you need to handle the null value.
Hi vanessafvg ! Thanks for your response! I tried adding another clause for handling if ProjectStage equals null, but it did not change anything. Thoughts?
