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...
I_LOVE_POWER_BI , Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
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