Conditional Column in Power Query

Iron Contributor

Dear Experts,

                     many time it happens that when I use conditional column, I see only these 2 options


where's as there are times when I get full options like these



It's not any IT issues as I am using same excel in same PC,

What could be the issue?

Thanks in Advance,



1 Reply


It depends on the values that are in the column. In the screenhot the column "Benutzerdefiniert" only has null values. There are only 2 operators that can be applied to these values which are "equals" or "does not equal" (in german "ist gleich" and "entspricht nicht"). Other operators such as "ends with" or "begins with" and so on wouldn't make sense with only null values in a column. 

conditional column.png