Forum Discussion
Remove opposite values
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.....
Hi thank you!
I found a solution on my own :D
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/#fuzzyMatching
This should help you solve your problem.
Hi thank you!
I found a solution on my own :D