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