Not able to add operator in conditional column

[kapil_arora1]

Hi, is there any way to add "begins with" in operator section drop down in Conditional column. I am only getting a smaller list of options. Refer screenshot below.

Thanks

[bhanu_gautam · Accepted solution]

@kapil_arora1 , You cannot add it directly but you can use mcode for it

if Text.StartsWith([YourColumnName], "YourText") then "TrueResult" else "FalseResult"

[rajendraongole1 · Accepted solution]

Hi @kapil_arora1  - Power Query's Conditional Column UI does not provide a "begins with" operator directly.

you can create a custom column and use Text.starts logic.

Text.StartsWith - PowerQuery M | Microsoft Learn

this works, please check.

[danextian · Accepted solution]

Hi @kapil_arora1 

Begins with is applicable only to text strings. Your Zip column is type number.

[kapil_arora1]

Thanks for the quick help.

[rajendraongole1 · Accepted solution]

Hi @kapil_arora1  - Power Query's Conditional Column UI does not provide a "begins with" operator directly.

you can create a custom column and use Text.starts logic.

Text.StartsWith - PowerQuery M | Microsoft Learn

this works, please check.

[kapil_arora1]

Thanks Rajendra for the quick help.

[bhanu_gautam · Accepted solution]

@kapil_arora1 , You cannot add it directly but you can use mcode for it

if Text.StartsWith([YourColumnName], "YourText") then "TrueResult" else "FalseResult"

[kapil_arora1]

Thanks Bhanu for the quick help.