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 ...
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
Community Champion
Community ChampionAnonymous ,
ImkeF is the amazing magician of m. Maybe she has some time to help.
Nathaniel
- ImkeF
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.
Thank you! I'll give it a try in the morning and let you know.
