Average by Date Range / Dynamic Average based on Slicer

[min-E]

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

[min-E]

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.

[lbendlin · Accepted solution]

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.

[min-E]

Thank you. Took the AVERAGE as a Measured Column. Added another column to format that and it works to show DHM.

[lbendlin]

A simple AVERAGE(<column>)  will do.