Forum Discussion
Solved
Merging multiple tables for yearly analysis
Hi, very new to this forum amd power bi as a whole so excuse me if this question has already been asked and answered. I have multiple monthly spreadsheets with the exact same data set (column hea...
Hello Ratso ,
if you want to have them all in one table, you need to merge, that's the only way to do it in power bi.
you can try doing it outside power bi on the data source level if this is applicable.
In this situation "Merge" is not the fuction you are looking for. With tables that have identical column headers but different data, say months or years, you want to use the "Append Queries". The way i see it is is merge tacks on new columns from another data set, and append stacks columns from another data set.