DAX First Occurance in SUMMARIZE, FIRST_VALUE equivalent
<p>I'm trying to create a DAX query to combine several records withing the same table and extract some values from these combined records.
The result should display not only the min and the max of start and stop time, but also the corresponding first and last locations.</p>
<h2>FROM</h2>
<h2>TravelID | TripID | StartTime | StopTime | StartLocation | StopLocation</h2>
<p>1001______| 99______|   08:00_______| 08:10_______ | 50AB___________| 99DE___________</p>
<p>1001______| 100_____|   08:12_______| 08:20________|59DB___________| 989FE___________</p>
<h2>TO</h2>
<h2>TravelID | StartTime | StopTime | StartLocation | StopLocation</h2>
<p>1001______| 08:00________| 08:20_______|50AB____________|989FE_________</p>
<p>My efforts so fare are:</p>
<pre><code>EVALUATE(
SUMMARIZE(
Source,
Source[BusinessDay]
,Source[TravelID]
,&quot;no of trips in travels&quot;, count(Source[TripID])
,&quot;min of starttime&quot;,  min(Source[StartTime])
,&quot;max of stoptime&quot;, max(Source[StopTime])
,&quot;first startlocation&quot;, ???
,&quot;last stoplocation&quot;, ???
))
</code></pre>
<p>I have experimented with FIRSTNONBLANK and RANKX without success.</p>
<p>The SLQ equivalent would be something like: FIRST_VALUE(StartLocation) OVER (PARTITION BY BusinessDay, travelId ORDER BY StartTime ASC) &quot;SiteIn&quot;.</p>