Forum Discussion

MYDATASTORY's avatar
MYDATASTORY
Resolver I
6 years ago
Solved

Average time

Hello,

Please advise me with DAX for calculating the Average time train journeys have taken. Time is recorded in HH: MM and the Date of the journey (DD:MM: YYYY)

I would like to see how long the journey has time on a Dairy and Monthly basis. i.e April  Average time was 3:30hrs(2hrs 30) this will be repressed on a bar graph. Thanks in advance

Date                    Time (Duration of the journey)

18/04/1989          02:30

19/04/1989          03:45

10/05/1989          02:55

16/05/1989          02:48