Remove duplicate text between columns

[alice11987]

In Power Query, I would like to get the column [Result] based on Column A and Column B. 

In Column A and Column B, there are duplication of texts, I would like to extract the part without duplications: 

Any ideas how I can achieve this in Power Query or DAX?

Thank you!

[ChiragGarg2512 · Accepted solution]

@alice11987 Create a column using this dax:

DIFF =

var _len1 = LEN('Table'[Column1]) + 1

var _len2 = LEN('Table'[Column2])

var _len = _len2-_len1

return

RIGHT('Table'[Column2], _len)

This would take the length of string in Column A and remove the length from Column B giving the length of desired string in Column C and RIGHT will take the right part of string of that length.

[ALLUREAN]

You can try this DAX approach. Create new calculated column:

In your example you are not taking into account the pure difference and in my case this will give underscore _ that can be removed if you like. I hope that this will be easy to be replicated in PQ, but for the moment I am not aware what is the functions there.