Forum Discussion

I_LOVE_POWER_BI's avatar
I_LOVE_POWER_BI
Helper III
5 years ago
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 row level in my base query material, which contains the information of each location from the other query. And by opening the list I want it to create new rows for all available combinations between material and locations.

 

In other words, I am too lazy to write down all possible combinations, so I want Power BI to add each combination based on my base query (material). So that in the end I have duplicated rows for each material but a unique material-location combination per row too.

 

Hope you got my point folks.

 

Thanks!

7 Replies

    • I_LOVE_POWER_BI's avatar
      I_LOVE_POWER_BI
      Helper III

      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....