Remove opposite values

[Anonymous]

Hi team,

is there anyway, at query level to avoid this:

Market

SYDMEL

MELSYD

BNEMEL

MELBNE

So basically if the bi-directional record comes out, I'd like to keep 1 only....

Thanks for your help

[Anonymous]

Hi,

Please take a look at Fuzzy Matching which is a new freview feature in the PowerBi october 2018 update: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-october-2018-feature-summary/#fuzzyMatchin...

This should help you solve your problem.

[Anonymous · Accepted solution]

Hi thank you!

I found a solution on my own 😄