Forum Discussion
Aggregating values from different tables to create visual with one table
Looking at your 3 tables, it seems like they use a common structure of Entity_ID, DMCC, and Paid_Amount.
Rather than have 3 tables, you can set up your Power Query (Transform data) to append all 3 tables into a new single table. Then you can mark the original tables as "Enable Load = False" and only import the resulting single table into Power BI.
You can do this on the home menu of transform data where you select "Append Queries as new"
Hi,
One of ways is to create append table in Power Query Editor, like below, and load it to Power BI desktop.
Please check the below picture and the attached pbix file.
Table.Combine - PowerQuery M | Microsoft Learn
let Source = Table.Combine({#"Table 1", #"Table 2", #"Table 3"}) in Source
Super UserHi,
One of ways is to create append table in Power Query Editor, like below, and load it to Power BI desktop.
Please check the below picture and the attached pbix file.
Table.Combine - PowerQuery M | Microsoft Learn
let
Source = Table.Combine({#"Table 1", #"Table 2", #"Table 3"})
in
Source
Jihwan_Kim Thanks for sharing the resources and your examples. It seems this may be the easiest way to get this done. I am a bit new to power bi but I'll try it out and see where I land with it. Thank you!
