Solved: Combining 3 sources with duplicate data

MusterBuster · ‎04-06-2018

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

v-chuncz-msft · ‎04-09-2018

@MusterBuster,

You may use Append Queries (Table.Combine) in Query Editor or UNION Function (DAX) to create a new table.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

v-chuncz-msft · ‎04-09-2018

@MusterBuster,

You may use Append Queries (Table.Combine) in Query Editor or UNION Function (DAX) to create a new table.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.