Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello all,
I have a raw data with count figures (number of sales per day per hour)
I used the sum function to get the total of each date per hour. (I'm also using a slicer to filter certain dates/hours) to compare the peak hours amoung diffrent timing/dates
However, I'm not sure how to get the average of the sales (when i use the average measure ) it only gives the average of certain timings e.g. most of my sales per hour is 2-3, so the average is 2.5. However the actual average depends on the sum of the total sales.
below is a sample of my data.
Date | hour | Sales No |
1-1-2023 | 0 | 2 |
1-1-2023 | 1 | 1 |
1-1-2023 | 2 | 3 |
1-1-2023 | 3 | 3 |
1-1-2023 | 4 | 2 |
1-1-2023 | 5 | 3 |
1-1-2023 | 6 | 2 |
2-1-2023 | 0 | 3 |
2-1-2023 | 1 | 2 |
Hi, @Merororiotuty_y
Based on the sample data you provided, can you tell me what output you expect? You can also show it with pictures or Excel.
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
57 | |
21 | |
19 | |
18 | |
16 |
User | Count |
---|---|
85 | |
80 | |
52 | |
37 | |
22 |