Forum Discussion
Merging Fields
I have 4 speadsheets loaded to my Power BI document. All of them have identical headers and identical # of columns. I just want there to be one. Hope that helps my question. (Maybe I don't need to merge them at all and I'm trying to do something not needed.??)
Hi, Medmanage101
According to your description, you have 4 tables which have identical headers and identical # of columns. In this case, I think you have two ways to combine them into one table:
One is using the “Append query” in the power query editor, like this:
Then add all the 4 tables into it:
Another is using the Union() function to create a calculated table in the Power BI:
Table= Union(Table1, Table2, Table3, Table4)More info about the Union() function in DAX
Then you can achieve your requirement.
Thank you very much!
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hey Medmanage101 ,
your description is not really clear for me as you are mixing fields and columns.
But you can combine column, for example directly in Power Query:
Merge columns (Power Query) - Excel (microsoft.com)
Or in DAX as a calculated column if they are text:
MyNewColumn = myTable[ColumnA] & myTable[ColumnB] & myTable[ColumnC]
Or combine them with a separator:
MyNewColumn = myTable[ColumnA] & "_" & myTable[ColumnB] & "_" & myTable[ColumnC]