Forum Discussion

campbellmurphy's avatar
campbellmurphy
Helper I
5 years ago
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 ...
Need Help
  • ImkeF's avatar
    ImkeF
    5 years ago

    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.

     

lbendlin's avatar
lbendlin
Super User
5 years ago

The equivalent Power Query function is likely List.Generate() but you can do this in many different ways, even with recursive functions if you want to explore that. Please provide sample data in usable format (not as a picture)  and show the expected outcome.

campbellmurphy's avatar
campbellmurphy
Helper I
5 years ago

Hi lbendlin,

 

I greatly appreciate your assistance.  I've included the Sample Data below.  I'm not able to post the tables within this reply as it's to large.  Table A & Table B are used to generate the expected outcome Table C.

The issue that I had in my previous post is I'm not able to create a relationship between the two tables in a normal PK/FK manner.

 

Sample Data:

Transformed Data Excel 

Transformed Data Power BI