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.
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.