Forum Discussion
Solved
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 pos...
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.
A simple AVERAGE(<column>) will do.