Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
hi ,
i added a pic that im trying to do in power bi but not succeed,
hope you understand 🙂
Solved! Go to Solution.
Hit the New Table button and add this DAX formula:
new table = ADDCOLUMNS( NATURALINNERJOIN( 'Table 1', SUMMARIZE( 'Table 2', 'Table 2'[closing balance] ) ), "sum balance", 'Table 1'[opening balance] + 'Table 2'[closing balance] )
Note that you need to have a relationship between the two source tables. Also if your real data is not quite like this sample data, you may have to use NATURALLEFTOUTERJOIN instead. Depends on whether or not one of the two tables has blanks or duplicates.
Proud to be a Super User!
Hit the New Table button and add this DAX formula:
new table = ADDCOLUMNS( NATURALINNERJOIN( 'Table 1', SUMMARIZE( 'Table 2', 'Table 2'[closing balance] ) ), "sum balance", 'Table 1'[opening balance] + 'Table 2'[closing balance] )
Note that you need to have a relationship between the two source tables. Also if your real data is not quite like this sample data, you may have to use NATURALLEFTOUTERJOIN instead. Depends on whether or not one of the two tables has blanks or duplicates.
Proud to be a Super User!
So where is the "New Table" button?
@efglynnUnder the Modeling tab in the ribbon.
Proud to be a Super User!
Frankly I'm surprised @KHorseman offered a DAX solution maybe because this was last year
I think the Query Editor is made for this!
Look at these 2 links describing all the joins and select which one you need in your case
http://www.excelguru.ca/blog/2015/12/16/merge-tables-using-outer-joins-in-power-query/
http://www.excelguru.ca/blog/2015/12/23/merge-tables-using-inner-and-anti-joins-in-power-query/
Once you know which join type you need its really easy to do in the Query Editor
Amazing!! THX
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |