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

anupambit1797_0-1693680560357.png

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

anupambit1797_1-1693680653469.png

 

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

1 Reply

@anupambit1797 

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