Forum Discussion

CMoppet's avatar
CMoppet
Icon for Helper IV rankHelper IV
4 years ago
Solved

Combining data from multiple tables in to single reporting data point

Hello,  I am on Day 2 using Power BI, so apologies in advance if I'm unable to explain my request with the correct lingo...   I have 4 tables of complaints data (Table 1, Table 2, Table 3, Table 4)...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi CMoppet - I would recommend appending the tables into one table in Power Query.  Use the Append table function.

    After combining the table you should remove any unnecessary columns.  If you still need to know which table provide which data, you can add a new column to each table before Combining.  In the new column, put something like "Table 1", "Table 2" etc.  This can be used in Slicer when visualising the data, or in CALCULATE functions to measures.



Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi CMoppet - I would recommend appending the tables into one table in Power Query.  Use the Append table function.

After combining the table you should remove any unnecessary columns.  If you still need to know which table provide which data, you can add a new column to each table before Combining.  In the new column, put something like "Table 1", "Table 2" etc.  This can be used in Slicer when visualising the data, or in CALCULATE functions to measures.