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
