Forum Discussion
Not able to add operator in conditional column
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
kapil_arora1 , You cannot add it directly but you can use mcode for it
if Text.StartsWith([YourColumnName], "YourText") then "TrueResult" else "FalseResult"
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.
6 Replies
Thanks for the quick help.
kapil_arora1 , You cannot add it directly but you can use mcode for it
if Text.StartsWith([YourColumnName], "YourText") then "TrueResult" else "FalseResult"
Thanks Bhanu for the quick help.
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.
Thanks Rajendra for the quick help.
