Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
You may use Append Queries (Table.Combine) in Query Editor or UNION Function (DAX) to create a new table.
You may use Append Queries (Table.Combine) in Query Editor or UNION Function (DAX) to create a new table.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
82 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |