Forum Discussion

walnei's avatar
walnei
Icon for Helper III rankHelper III
8 years ago
Solved

AVERAGE TIME

Could you help me, I would like to measure the time spent by pilots between the start time and the end time, my base is print 1.   I tried using Max and Min for date but I could not solve it....
Need Help
  • MFelix's avatar
    MFelix
    8 years ago

    Hi walnei,

     

    Add the following measure to your model:

    Time Med =
VAR Star_Time =
    CALCULATE ( MIN ( Table1[Time] ) )
VAR End_time =
    CALCULATE ( MAX ( Table1[Time] ) )
RETURN
    FORMAT ( End_time - Star_Time; "hh:mm:ss" )

    Final result below:

     

     

    Regards,

    MFelix

MFelix's avatar
MFelix
Icon for Super User rankSuper User
8 years ago

Hi walnei,

 

Add the following measure to your model:

Time Med =
VAR Star_Time =
    CALCULATE ( MIN ( Table1[Time] ) )
VAR End_time =
    CALCULATE ( MAX ( Table1[Time] ) )
RETURN
    FORMAT ( End_time - Star_Time; "hh:mm:ss" )

Final result below:

 

 

Regards,

MFelix