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 ...
Need Help
amitchandak's avatar
amitchandak
Super User
5 years ago

I_LOVE_POWER_BI , Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

 

 

  • I_LOVE_POWER_BI's avatar
    I_LOVE_POWER_BI
    Helper III
    5 years ago

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

    • amitchandak's avatar
      amitchandak
      Super User
      5 years ago

      I_LOVE_POWER_BI , Create a table using a list or Enter data and append it to your existing Table

      • I_LOVE_POWER_BI's avatar
        I_LOVE_POWER_BI
        Helper III
        5 years ago

        That didn't work - because it add only null values in all other columns.

         

        So here is more concrete what I want: