Forum Discussion
Combining tables
Dear All, I have three tables as below. 1st table , 2nd table , 3rd table Is there a way to get these three tables to a one table as below. Thank Y...
Hey! Yes there are a few ways, especially if you have access to the raw data.
The easiest way is to use PowerQuery's in-built append queries function to simply merge all your tables.Otherwise, if you need to create a table with DAX, then you can either create a new table and use the DAX CombinedTable = UNION(Table1, Table2, Table3),
vicky_
Super User
Super UserHey! Yes there are a few ways, especially if you have access to the raw data.
The easiest way is to use PowerQuery's in-built append queries function to simply merge all your tables.
Otherwise, if you need to create a table with DAX, then you can either create a new table and use the DAX CombinedTable = UNION(Table1, Table2, Table3),