Forum Discussion

RedJedi_81's avatar
RedJedi_81
Regular Visitor
1 year ago

Calculating Daily and All-Time Average Rank

Hello everyone, I'm trying to calculate both a daily rank and an all-time average rank in Power BI.   Dataset Overview: I have a table in Power Query with the following columns: Date Time of Da...
Need Help
RedJedi_81's avatar
RedJedi_81
Regular Visitor
1 year ago
DateChannelDaypartRankAverage ViewsShare
15/01/2025BBC NewsALL DAY1851001.19%
15/01/2025GB NewsALL DAY2701000.98%
15/01/2025Sky NewsALL DAY3674000.94%
14/01/2025BBC NewsALL DAY2765001.12%
14/01/2025GB NewsALL DAY1779001.15%
14/01/2025Sky NewsALL DAY3739001.09%
13/01/2025BBC NewsALL DAY1835001.18%
13/01/2025GB NewsALL DAY2827001.17%
13/01/2025Sky NewsALL DAY3717001.01%
12/01/2025BBC NewsALL DAY11077001.33%
12/01/2025GB NewsALL DAY3670000.83%
12/01/2025Sky NewsALL DAY2727000.90%
11/01/2025BBC NewsALL DAY11000001.38%
11/01/2025GB NewsALL DAY3682000.94%
11/01/2025Sky NewsALL DAY2694000.96%
10/01/2025BBC NewsALL DAY11006001.41%
10/01/2025GB NewsALL DAY2857001.20%
10/01/2025Sky NewsALL DAY3670000.94%
09/01/2025BBC NewsALL DAY11135001.58%
09/01/2025GB NewsALL DAY2931001.30%
09/01/2025Sky NewsALL DAY3789001.10%
08/01/2025BBC NewsALL DAY2929001.25%
08/01/2025GB NewsALL DAY1995001.33%
08/01/2025Sky NewsALL DAY3730000.98%
07/01/2025BBC NewsALL DAY3734001.05%
07/01/2025GB NewsALL DAY1860001.23%
07/01/2025Sky NewsALL DAY2774001.10%
06/01/2025BBC NewsALL DAY3786001.08%
06/01/2025GB NewsALL DAY1851001.17%
06/01/2025Sky NewsALL DAY2795001.10%
05/01/2025BBC NewsALL DAY11061001.27%
05/01/2025GB NewsALL DAY3706000.85%
05/01/2025Sky NewsALL DAY2733000.88%
04/01/2025BBC NewsALL DAY1821001.13%
04/01/2025GB NewsALL DAY2737001.01%
04/01/2025Sky NewsALL DAY3722000.99%
03/01/2025BBC NewsALL DAY2835001.12%
03/01/2025GB NewsALL DAY1878001.18%
03/01/2025Sky NewsALL DAY3741000.99%
02/01/2025BBC NewsALL DAY11012001.33%
02/01/2025GB NewsALL DAY2735000.97%
02/01/2025Sky NewsALL DAY3695000.91%
01/01/2025BBC NewsALL DAY11186001.26%
01/01/2025GB NewsALL DAY3673000.71%
01/01/2025Sky NewsALL DAY2979001.04%

This includes the date range. I created two charts to resolve the issue. One for average, one for selected date. The expected outcome would be in a bar chart, like below:

 

I'm not sure how to express this within the table.

RedJedi_81's avatar
RedJedi_81
Regular Visitor
1 year ago
DateChannelDaypartRankAverage ViewsShare
31/01/2025BBC NewsALL DAY1938001.33%
31/01/2025GB NewsALL DAY3661000.94%
31/01/2025Sky NewsALL DAY2816001.16%
30/01/2025BBC NewsALL DAY11020001.52%
30/01/2025GB NewsALL DAY3947001.41%
30/01/2025Sky NewsALL DAY2955001.43%
29/01/2025BBC NewsALL DAY2815001.21%
29/01/2025GB NewsALL DAY1882001.31%
29/01/2025Sky NewsALL DAY3695001.04%
28/01/2025BBC NewsALL DAY2702001.06%
28/01/2025GB NewsALL DAY1738001.12%
28/01/2025Sky NewsALL DAY3677001.03%
27/01/2025BBC NewsALL DAY1805001.16%
27/01/2025GB NewsALL DAY2799001.15%
27/01/2025Sky NewsALL DAY3784001.13%
26/01/2025BBC NewsALL DAY11075001.40%
26/01/2025GB NewsALL DAY3546000.71%
26/01/2025Sky NewsALL DAY2843001.10%
25/01/2025BBC NewsALL DAY1992001.42%
25/01/2025GB NewsALL DAY3533000.76%
25/01/2025Sky NewsALL DAY2778001.11%
24/01/2025BBC NewsALL DAY21058001.38%
24/01/2025GB NewsALL DAY3761000.99%
24/01/2025Sky NewsALL DAY11061001.38%
23/01/2025BBC NewsALL DAY1995001.38%
23/01/2025GB NewsALL DAY3876001.22%
23/01/2025Sky NewsALL DAY2949001.32%
22/01/2025BBC NewsALL DAY1871001.21%
22/01/2025GB NewsALL DAY3728001.01%
22/01/2025Sky NewsALL DAY2861001.20%
21/01/2025BBC NewsALL DAY2848001.27%
21/01/2025GB NewsALL DAY3679001.02%
21/01/2025Sky NewsALL DAY1897001.34%
20/01/2025BBC NewsALL DAY11397001.93%
20/01/2025GB NewsALL DAY31142001.58%
20/01/2025Sky NewsALL DAY21216001.68%
19/01/2025BBC NewsALL DAY11294001.64%
19/01/2025GB NewsALL DAY3601000.76%
19/01/2025Sky NewsALL DAY2869001.10%
18/01/2025BBC NewsALL DAY1840001.15%
18/01/2025GB NewsALL DAY3539000.74%
18/01/2025Sky NewsALL DAY2642000.88%
17/01/2025BBC NewsALL DAY3627000.89%
17/01/2025GB NewsALL DAY2677000.96%
17/01/2025Sky NewsALL DAY1691000.98%

 

Rest of the dates