Forum Discussion
Conditional Column in Power Query
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,
Br,
Anupam
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.
