Forum Discussion
Average by Date Range / Dynamic Average based on Slicer
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.
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.