Forum Discussion
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 ...
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
Thank you... the two columns are in different tables. can PowerQuery reference a different table?
Hi Anonymous ,
Sorry, I missed that. Let me revise.
NathanielHi Anonymous ,
Please check this post out. https://community.powerbi.com/t5/Desktop/joinAlgorithm-and-keyEqualityComparers/m-p/182148#M79842 ImkeF is the magician of M.
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