Forum Discussion
Average by Date Range / Dynamic Average based on Slicer
Hello,
I have a list of dates and their sum.
Looking to create a Card that displays the Average based on what is selected in a Date Slicer.
Tried applying various Solutions from other posts and none seem to work for me. Help is so so appreciated.
Date From 2/2/2024 To 2/4/2024 =
Sum(281, 88, 218) / 4 =
Average 146.75
| Date | Sum |
| 2/16/2024 12:21 | 212 |
| 2/7/2024 0:22 | 98 |
| 2/16/2024 12:22 | 3 |
| 2/2/2024 17:12 | 88 |
| 2/2/2024 14:00 | 281 |
| 2/4/2024 10:45 | 218 |
| 2/4/2024 22:45 | 0 |
| 2/5/2024 0:47 | 0 |
| 2/6/2024 10:18 | 94 |
| 2/5/2024 10:44 | 134 |
Proper display of durations is always tricky especially if you try to sort multiple values. If it is only a single value in a card visual then you can use the FORMAT function to show it as needed. You will need to decide if you want to suppress zero hours and/or days. Probably also don't want to show leading zeros for hours.
4 Replies
A simple AVERAGE(<column>) will do.
THANK YOU. You are right. And I think that helps me understand my problem.
My Sum is a duration in minutes.
Then I have another custom column to format that into D H M - this is not changing in my card.
Is there a way to format my Sum as Duration (in minutes) and round the average to the closest whole number?
Or is the issue the DHM formatting in general?
Note - let me know if this should be a separate post. You did answer my original question. Didn't mean to not describe entire issue - just looking at this way too long.
Proper display of durations is always tricky especially if you try to sort multiple values. If it is only a single value in a card visual then you can use the FORMAT function to show it as needed. You will need to decide if you want to suppress zero hours and/or days. Probably also don't want to show leading zeros for hours.
Thank you. Took the AVERAGE as a Measured Column. Added another column to format that and it works to show DHM.
