https://community.fabric.microsoft.com/t5/s/yrjkf47658/tracker alwright Tracker Thu, 17 Sep 2026 18:58:57 GMT 2026-09-17T18:58:57Z https://community.fabric.microsoft.com/t5/Power-Query/If-left-starts-with-this-return-this/m-p/3889836#M128130 <P>This was exactly what I was looking for, thank you!&nbsp; And thank you for keeping it simple, I really appreciate it.</P> Fri, 03 May 2024 17:50:45 GMT https://community.fabric.microsoft.com/t5/Power-Query/If-left-starts-with-this-return-this/m-p/3889836#M128130 alwright 2024-05-03T17:50:45Z https://community.fabric.microsoft.com/t5/Power-Query/If-left-starts-with-this-return-this/m-p/3889728#M128127 <P>Very new to Power BI and Power Query.&nbsp; I have a column A with values that look like this: (0102) and (0506), etc.&nbsp; I want a column B labled "Region" where, if column A starts with "(01" then column B spits out "Region 1".&nbsp; If column A is "(05", then column B is "Region 5".&nbsp; How would I do that?</P><P>&nbsp;</P><P>Thank you.</P> Fri, 03 May 2024 16:31:33 GMT https://community.fabric.microsoft.com/t5/Power-Query/If-left-starts-with-this-return-this/m-p/3889728#M128127 alwright 2024-05-03T16:31:33Z