Forum Discussion
I_LOVE_POWER_BI
Helper III
Helper IIIPower 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_BIHelper III
Helper IIIThat didn't work - because it add only null values in all other columns.
So here is more concrete what I want:
amitchandak
Super User
Super UserI_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
- I_LOVE_POWER_BI
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???
- I_LOVE_POWER_BI
Here is the answer:
2 Tricks to Create Unique Combinations From Multiple Columns – Power Query #7 - YouTube
Super easy actually...