Forum Discussion

anupambit1797's avatar
anupambit1797
Iron Contributor
Sep 02, 2023

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

  • 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.