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 ,

 

So the two tables have relationship with each other, right? Could you please share some sample data?

 

Regards,

Jimmy Tao

  • 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
      Icon for Community Support rankCommunity 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.