Forum Discussion
Solved
Combining 3 sources with duplicate data
Hi everyone!
Slowly losing my mind, happy Friday!
I have 3 data sources. Each has a list of review scores from different sources. All of these scores are out of 5. So each source looks like this:
| Store Name | Review Score | Date and Time |
| Shop 1 | 1 | 01/01/2018 |
| Shop 2 | 2 | 02/01/2018 |
| Shop 1 | 5 | 03/01/2018 |
| Shop 5 | 4 | 04/01/2018 |
| Shop 1 | 4 | 05/01/2018 |
| Shop 4 | 5 | 06/01/2018 |
| Shop 5 | 2 | 07/01/2018 |
| Shop 2 | 4 | 08/01/2018 |
| Shop 1 | 5 | 09/01/2018 |
| Shop 4 | 3 | 10/01/2018 |
I need to combine these 3 data sources to get an overall average review score for each store within a specified time frame. So my ideal table would look like:
| Store Name | Average Review Score |
| Shop 1 | 3.5 |
| Shop 2 | 2 |
| Shop 3 | 5 |
| Shop 4 | 4.3 |
| Shop 5 | 2.5 |
Any ideas on how to reach that solution?
M
You may use Append Queries (Table.Combine) in Query Editor or UNION Function (DAX) to create a new table.
1 Reply
You may use Append Queries (Table.Combine) in Query Editor or UNION Function (DAX) to create a new table.