CODEWITHSUNDEEP
appendpowerbi
Switzerland2020
Switzerland2020

Reputation: 11

PowerBI: Appending tables with calculated columns

i have uploaded into Power BI 4 Tables: 1) Exchange Rates 2) Ledger Tree 3) Actuals results 4) Forecast. Tables 3 and 4 had different columns or information (eg. 3 showed values by ledger in usd and 4 in local currencies; table 3) is not showing the ledger currency while Table 4 does), so I had to add in both several calculated columns (including looking values from tables 1 and 2) to make them look alike.

I would like now to put table 3 and 4 above one another one but I am not sure how to do it?

Any help is much appreciated

Upvotes: 1

Views: 1095

Answers (1)

Jon
Jon

Reputation: 4967

In Power Query to Union tables use append query

When selecting this, you can add to the existing query, or create a new table from the appended tables. If you do append you can select the old tables no longer used, and turn off 'Enable Load' so the reference table isn't loaded into the Power Pivot

In DAX, you can union tables using the Union function

Upvotes: 1

Related Questions