Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi everyone!
I am currently working with three tables that I need to combine into one. In each table, I have a "Name" column. I would like to stack the names on top of one another to create on supertable with all of their names. I don't need to copy the other columns, just make one with the list of names. The reason I'm trying to merge the names is so that I may constantly update each table and have a list of all names from all tables. Here's a sample image of what I'm hoping for:
Please note that I also want to be able to update the tables if I add names so that the list is also updated. I also made the demonstration through excel but would like to do it in Power BI!
Thanks!!
Solved! Go to Solution.
Hi @12scml,
You can create a calculated table using below DAX formula:
NewTable = UNION ( SELECTCOLUMNS ( Table1, "Name", Table1[Name] ), SELECTCOLUMNS ( Table2, "Name", Table2[Name] ), SELECTCOLUMNS ( Table3, "Name", Table3[Name] ) )
It will update automatically when you refreshing the source tables (Table1, Table2, Table3).
Best regards,
Yuliana Gu
Hi @12scml,
You can create a calculated table using below DAX formula:
NewTable = UNION ( SELECTCOLUMNS ( Table1, "Name", Table1[Name] ), SELECTCOLUMNS ( Table2, "Name", Table2[Name] ), SELECTCOLUMNS ( Table3, "Name", Table3[Name] ) )
It will update automatically when you refreshing the source tables (Table1, Table2, Table3).
Best regards,
Yuliana Gu
User | Count |
---|---|
103 | |
90 | |
78 | |
72 | |
68 |
User | Count |
---|---|
110 | |
96 | |
95 | |
74 | |
71 |