Solved: Remove opposite values

Anonymous · ‎10-23-2018

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 · ‎10-23-2018

Hi thank you!

I found a solution on my own 😄

Anonymous · ‎10-23-2018

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 · ‎10-23-2018

Hi thank you!

I found a solution on my own 😄

Remove opposite values