Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

DAX - Help with FIND

Hi, I have two tables - one contains our Authorization code [AuthCode], and the other from the vendor contains their version of our auth code. The vendor [Authorization] field is not consistent and ...
Need Help
v-yuta-msft's avatar
v-yuta-msft
Icon for Community Support rankCommunity Support
6 years ago

Anonymous ,

 

Change the AuthCode from number type to text and then merge the two tables using Fuzzy matching as below:

 

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

I'm not sure how this was marked as the solution... this didn't work for me... I tried adjusting the setting on the fuzzy match a couple of times, and it resulted in 0 matches. (and took forever to refresh).