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
Anonymous's avatar
Anonymous
Not applicable
6 years ago

The Claim Table contains authorization numbers that have additional prefix/suffix depending on the payer and is not a uniqe list - auth numbers can be repeated.

 

The Auth table is a unique list and contains our actual Auth number. I'm trying to join if the AuthCode string is found in the Authorization field.

 

 

v-yuta-msft's avatar
v-yuta-msft
Community 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).