I am struggling to find a DAX or M code solution to my situation. I can only replicate this using VBA, which I do not want to do. In short, I want to know how to loop through tables using m code or Dax. Is it even possible?
- I have two tables.
- Table one contains one column that contains random text values.
- Table two is the table shown in the below image.
For example, I have a value in table one
s cell "AmznPrimeDE*123456DE". I want to have a function that will search every string from table twos column “search” and if true, return me a value from column “Output.”