Average time

[MYDATASTORY]

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

[amitchandak · Accepted solution]

@MYDATASTORY , refer if these can help

https://social.technet.microsoft.com/wiki/contents/articles/33644.powerbi-aggregating-durationtime-i...

https://radacad.com/calculate-duration-in-days-hours-minutes-and-seconds-dynamically-in-power-bi-usi...

https://community.powerbi.com/t5/Quick-Measures-Gallery/Chelsie-Eiden-s-Duration/m-p/793639#M389

[MYDATASTORY]

@amitchandak  Many thanks works..