Forum Discussion
Power Query: Add rows based on values in a list (based on combinations
Here is the answer:
2 Tricks to Create Unique Combinations From Multiple Columns – Power Query #7 - YouTube
Super easy actually...
This is less about the actual use case but more a general question whether it is possible at all or not to create new rows based on invoking a list into each row....
I_LOVE_POWER_BI , Create a table using a list or Enter data and append it to your existing Table
That didn't work - because it add only null values in all other columns.
So here is more concrete what I want:
I_LOVE_POWER_BI , Expand the list into rows. Either you should see an option on column two right angle(opposite direction) or on the right click.
refer if needed
https://docs.microsoft.com/en-us/powerquery-m/table-transformrows
The problem is, I don't know how to get to step 2 in my picture above. How to add such a column that includes to list???