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 tables have a relationship on another field, but only many:many... I'm not able to share the data because it's healthcare data.

 

 

 

 

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