Merge

[shashar11]

Hi Everyone-

I have to append/merge15 excel spreadsheets for building dashboards. Each spreadsheet has between 40-60 columns. Column  headers are not same either. However, for the purpose of dashboards, I need only 10 columns(consistent through out each spreadsheet) to merge. Can anyone please suggest the best way to approach this scenario?

Thank You!

[amitchandak]

Union with Summarize or add columns can work.

Or you can refer : https://docs.microsoft.com/en-us/power-bi/desktop-shape-and-combine-data

union(
summarize(table,table[date],"Var","Variable 1", "Sum",sum(table[variable 1]), "Count",count(table[variable 1])),
summarize(table,table[date],"Var","Variable 2", "Sum",sum(table[variable 2]), "Count",count(table[variable 2]))
)

It is not necessary to have aggregated columns in summarize 

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges

Connect on Linkedin