Forum Discussion
Group, Merge or concatenate Table
I have to concatenate 4 tables. Turn this Table: 2014 Column: ID, Year, Value Table: 2015 Column: ID, Year, Value Table: 2016 Column: ID, Year, Value Table: 2017 Column: ID, Year, Value ...
Hey,
You can Append as well as Merge using the query-editor ( See image)
Alternatively you can use a DAX formula using the concatenate function.
For more info on this function use this link: https://msdn.microsoft.com/en-us/library/ee634811.aspx
Good luck
Hey,
You can Append as well as Merge using the query-editor ( See image)
Alternatively you can use a DAX formula using the concatenate function.
For more info on this function use this link: https://msdn.microsoft.com/en-us/library/ee634811.aspx
Good luck
Or just combine the tables in Power Query (M):
= #"2014"&#"2015"&#"2016"&#"2017"