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
Community Support
6 years ago

Anonymous ,

 

Could you please share two simple sample tables? Just add the necessary columns, several rows. So I could do analysis on your issue. Please make sure do not input any sensitive data.

 

Regards,

Jimmy Tao

 

 

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).