Forum Discussion
Solved
Power Query: Add rows based on values in a list (based on combinations
Hi Power BI gurus! My question, not sure if that is actually possible to realize: I have a query with materials and another query with locations. Now what I want to do is to insert a list on ...
Here is the answer:
2 Tricks to Create Unique Combinations From Multiple Columns – Power Query #7 - YouTube
Super easy actually...
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???
Here is the answer:
2 Tricks to Create Unique Combinations From Multiple Columns – Power Query #7 - YouTube
Super easy actually...