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.
Your word "null" and the value of null are unfortunately not the same thing. If your original column is a calculated column, consider changing how it derives the null value.
Alternatively, there could an option for blanks in your conditional column?
Thanks for your response ExcelMonke! The M in the Advanced Editor implise it does recognize null as true null, not as text null (see screenshot I added at the end below). If it read it as null, wouldn't it just not trigger the if statement, instead of making the field an Error?