The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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!
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
@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
User | Count |
---|---|
77 | |
75 | |
36 | |
31 | |
28 |
User | Count |
---|---|
95 | |
81 | |
55 | |
48 | |
48 |