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
Nathaniel_C's avatar
Nathaniel_C
Icon for Community Champion rankCommunity Champion
6 years ago

Hi Anonymous ,
Sorry, I missed that. Let me revise.
Nathaniel

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    I think this is probably the way to go... I'm just not familiar enough with M yet to get it to work.

    • Nathaniel_C's avatar
      Nathaniel_C
      Icon for Community Champion rankCommunity Champion
      6 years ago

      Anonymous ,
      ImkeF  is the amazing magician of m. Maybe she has some time to help.
      Nathaniel

      • ImkeF's avatar
        ImkeF
        Icon for Community Champion rankCommunity Champion
        6 years ago

         Hi Anonymous 

        you can create a custom column with this code:

        Table.SelectRows(Auths, (x) => Text.Contains([Authorization], x[AuthCode]))

        This will return a column with the matching rows from the Auth-table.

        Make sure to buffer the Auths-table, as this is operation won't be fast.