Power Query: Extract string from one column based on another column in the same table

[aury_lola]

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 trying to isolate follow any kind of logic in terms of number of characters, delimiter, etc. I only know that "Combination" = "Prefix" + something.

How can I isolate that something extra (in yellow above) either in the same column or as a custom column?

I can't use the extract or the split by delimiter functions because of the lack of logic. And this table comes from a source that I cannot edit it, but I still need to find a way to isolate that something extra.

Ideally I'd like to do it in power query, but I could make it work in DAX as well if the first is not possible.

Thank you advance for any help!

[ryan_mayu · Accepted solution]

@aury_lola 

is this what you want?

=Text.End([Combination],Text.Length([Combination])-Text.Length([Prefix]))

[aury_lola]

That's exactly what I was looking for! Thank you very much!

[ryan_mayu]

you are welcome

[lbendlin]

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.