Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
Hi,
I have 1 excel file with multiple daily reports in different sheets. The data is cleaned and in the same table format. How do I merge the sheets in Power BI in order to create visualizations that compare the different reports with eachother?
I am quite new to Power BI and managing data in general.
Thank you, appreciate any help.
F
Solved! Go to Solution.
Hi Freddus,
Try appending the tables 😄
Here you have the explanation & differences between appending & merging tables in PBI
http://radacad.com/append-vs-merge-in-power-bi-and-power-query
Hi Freddus,
Try appending the tables 😄
Here you have the explanation & differences between appending & merging tables in PBI
http://radacad.com/append-vs-merge-in-power-bi-and-power-query
| User | Count |
|---|---|
| 43 | |
| 35 | |
| 29 | |
| 17 | |
| 16 |
| User | Count |
|---|---|
| 63 | |
| 57 | |
| 41 | |
| 21 | |
| 20 |