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 ,
In Power Query, add a Conditional Column

or if you want a calculated column:

Yes = if(CONTAINSSTRING(myTab[Authorization],myTab[AuthCode]),"Yes","No")


 
Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thank you... the two columns are in different tables. can PowerQuery reference a different table?

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