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,
I have tasks which have start time and end time.
I took those tasks and distributed them on 24 H basis and it shows me on line chart how task creation and task finishing times are distributed on 24 H x axis. But it shows me the whole count from first period till last day. I need it to show me on average what amount of tasks is created per hour, distributed on 24H x axis.
Solved! Go to Solution.
Hi,
It sounds like, for each hourly block, you want to calculate a count per day and average those counts over your entire date range. For that you would need to use the AVERAGEX function.
Treat this as a template as I'm not sure of your table/column names, or whether you have a Date table:
= AVERAGEX ( VALUES ( 'Date'[Date] ), CALCULATE ( COUNT ( YourTable[YourColumn] ) ) )
A measure like this would work whether you're looking at hourly blocks or complete days.
Hi,
It sounds like, for each hourly block, you want to calculate a count per day and average those counts over your entire date range. For that you would need to use the AVERAGEX function.
Treat this as a template as I'm not sure of your table/column names, or whether you have a Date table:
= AVERAGEX ( VALUES ( 'Date'[Date] ), CALCULATE ( COUNT ( YourTable[YourColumn] ) ) )
A measure like this would work whether you're looking at hourly blocks or complete days.
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |