Combine values from different tables based on an identifier, then group and sum by that value

[Amy_H_]

I'm fairly new to DAX and am trying to get a total amount that combines values from 3 data tables based on an Account number.

For example, if this is my data:

Table 1                                             Table 2                                           Table 3

Account #      Amount$                 Account#          Amount$              Account#         Amount$

1111               10                            1114                 30                         1111                 20

1112               20                            1111                 20                         1114                 10

1113               50                            1113                 10                         1112                 50

1111               10                            1113                 10                         1114                 10

I want a table that has the following:

New table

Account#     Total Combined Amount$

1111             60

1112             70

1113             70

1114             50

The added complexity is that the Account column in Table 1 is a calculated column, which is returning the Account number based on a unique identifier column which is in Table 1 (data/fact table) and Table 4 (look up/dim table):

      Account = MINX(FILTER('Table 4',SEARCH('Table 4'[UniqueID],'Table 1'[UniqueID#],1,0)>0),'Table4'[Account (return value)])

I've done some digging round online for a solution, but haven't had much luck so far.  Any assistance would be great!

[miTutorials]

Please see the detailed video on how you can append multiple tables in PowerBI.

How to Join Tables | Merge Columns and Append Rows in PowerBI | MiTutorials - YouTube

[Arul]

@Amy_H_ ,

Why don'y you append all the 3 tables in Power Query Editior?
https://learn.microsoft.com/en-us/power-query/append-queries

Thanks,

Arul