Don't miss your chance to take exam DP-600 or DP-700 on us!
Request nowLearn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
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. I need a solution according to print 2. Can you help me?
Solved! Go to Solution.
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
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @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
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsShare feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
Check out the February 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 51 | |
| 40 | |
| 37 | |
| 14 | |
| 14 |
| User | Count |
|---|---|
| 85 | |
| 69 | |
| 38 | |
| 29 | |
| 27 |