Forum Discussion
Create relationships between multiple data sources
Hi all,
I'm a new user in power bi and have, what I suppose to be, an easy-solved problem. I currently have four different data sources (country A, B,C,D) imported from excel. The four excel sheets have an identical layout, thus having the same columns but different data inputs for "sales", "expenses" etc. All of them are however inlcuding the same values for year, period and date.
I want to combine these into the same report and further create a slicer where I can choose to between each country and its data.
Would really appricate some help, thanks!
Anonymous
I would combine all tables into one. You can do that through Power Query Editor --> Home --> Append Queries --> Append Queries as new
Before combining them make sure you add another column to each table and give them a specific name so as to distiguish its values from the other tables.
2 Replies
Anonymous
I would combine all tables into one. You can do that through Power Query Editor --> Home --> Append Queries --> Append Queries as new
Before combining them make sure you add another column to each table and give them a specific name so as to distiguish its values from the other tables.