Forum Discussion
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
MYDATASTORY , refer if these can help
https://community.powerbi.com/t5/Quick-Measures-Gallery/Chelsie-Eiden-s-Duration/m-p/793639#M389
2 Replies
- amitchandakSuper User
MYDATASTORY , refer if these can help
https://community.powerbi.com/t5/Quick-Measures-Gallery/Chelsie-Eiden-s-Duration/m-p/793639#M389
- MYDATASTORYResolver I
amitchandak Many thanks works..