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'm trying to joining multiple tables and i dont know how to do it.
Table 1:
id | name | value |
1 | aaa | 123 |
2 | bbb | 234 |
3 | ccc | 345 |
Table 2:
id | name | value |
1 | aaa | 432 |
2 | bbb | 543 |
4 | ddd | 154 |
5 | eee | 346 |
6 | fff | 908 |
Expected result:
id | name | Table1.value | Table2.value |
1 | aaa | 123 | 432 |
2 | bbb | 234 | 543 |
4 | ddd | null | 154 |
5 | eee | null | 346 |
3 | ccc | 345 | null |
6 | fff | null | 908 |
I tried to append, merge this queries using FULLOUTERJOIN, however i wasnt successfull.
Someone please can help me?
Solved! Go to Solution.
Hi @luisseneto,
1. rename the value columns (Table1.value, Table2.Value)
2. Append Table1 & Table2
3. Group by id, name (Sum Table1.Value, Table2.Value )
Create a new table and add the following formula:
Table = UNION(SELECTCOLUMNS(Table1,"ID", Table1[id],"Name", Table1[name],"Value1", Table1[value],"Value2", "" ), SELECTCOLUMNS(Table2,"ID", Table2[id],"Name", Table2[name],"Value1", "","Value2", Table2[value] ), )
Hi @luisseneto,
1. rename the value columns (Table1.value, Table2.Value)
2. Append Table1 & Table2
3. Group by id, name (Sum Table1.Value, Table2.Value )
You are welcome
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 |
---|---|
112 | |
97 | |
84 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |