Forum Discussion
Solved
Power Query: Extract string from one column based on another column in the same table
Hi everyone, I have a table with 2 columns where one is the combination of the other one plus some characters. As you can see in the image below, neither the "Prefix" nor the characters I'm tryin...
Use Text.StartsWith - PowerQuery M | Microsoft Learn to check if the second column value starts with the first column value. Then use Text.Range - PowerQuery M | Microsoft Learn to return the rest of the second string.