Forum Discussion
Solved
Alternative to DAX GENERATE Function in Power Query
Hi Everyone, I have two working tables (A & B) and the ideal transformed result table (C). I need to generate the same table within Power Query instead of DAX. Does anyone know if this is possible ...
Hi campbellmurphy ,
if you're interested in a more generic approach for this kind of wildcard matches, you can check out the file enclosed.
It creates wildcard profiles for each kind of wildcard distribution and uses a simple join at the end. It should be fairly fast as long as there are not too many different wildcard profiles.
it's a bit messy. I hope it will be useful for you.
Thanks Rocco, I really appreciate your assistance. In the end I went with another solution but I agree that yours works and is a good alternative