Forum Discussion
Power Query - full join or create combine list
Hi, I have to list with generated values in Power Query: "List.Numbers(0, 25)" "List.Dates(#date(2019, 10, 27), 3, #duration(1, 0, 0, 0))" and I want to full join it as in the pictures below. ...
Please can you confirm why you wish to do this. Most of the time, there is another method to achieve the same goal.
To answer you question, you could pivot, then duplicate and unpivot... but the method is not ideal
You could create a column column on the date table which generate your list of numbers, then all you would need to do is expand them (this would then create duplicates of your dates as required)
Regards,
Mathew
Seems like you need a crossjoin.
Create a dummy column in each of the tables. Give the same value to all the rows of the dummy column in both tables (e.g.: "1"). Inner joinjoin tables on the dummy columns. Voila: you have the Cartesian product of the tables.