Forum Discussion
Solved
IF Text Starts With in Power Query
Hi all how do i use the Text.StartsWith in Power Query in this scenario if i had a column saying something like London Region or London Area etc but i just wanted to say if coln starts with london t...
Hi,
Please try this
if Text.StartsWith([RegionColumn], "London") then "London Group" else "Other"
If this workes, please consider accepting as a solution and give kudo 🙂
Excellent, thank you