Forum Discussion

v-teven's avatar
v-teven
Regular Visitor
8 years ago

How to add rows based on values in other table?

Hi, I have two tables connected by the "attribute" field - which states the country, year, quarter and segment. One of the tables contains the "values" and these are unique entries by quarter and seg...
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Lets name your tables as Table 1 ( with measures & row to be added) and Table 2 ( it has extra rows)

 

You can merge these tables in Power Query with Right outer join.

 

In Power Query -> Home -> Merge-> Merge Queries, Table1 as First table and Table 2 as 2nd table , join type is Right outer join.

Now, you will have the missing row, with null value in Measure field .

 

Thanks

Raj

v-teven's avatar
v-teven
Regular Visitor
8 years ago

Thanks for your reply. 

 

I want to avoid merging because the query of table 1 is too large and takes a long time to load. Also, I'm using it in the report for another tables with measures that are all connected. I think redoing everything again would give me more work than trying a different alternative.  Any alternative suggestion would be really appreciated. 

 

Thank you!

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi v-teven,

     

    I think union function(dax) and Table.InsertRows(M query) will suitable for your requirement:
    UNION Function (DAX)

    Table.InsertRows

     

    Regards,

    Xiaoxin Sheng