Thank you, Roger, highly appreciate your feedback and time!
Will patiently await your follow-up.
If I may:
Question 2. Please help to compose a measure version of the calculated column? I cannot get it to work.
Question 3. The below seems to work (last line changed to give mileage difference and not days difference). Does it look okay to you? (This mileage difference would be a new and improved answer to the current post here where you posted this reply. The days difference was the answer to this post.)
====================================================================
DIFF in mileage =
var temp =
TOPN (
1,
FILTER (
WO_JOBS,
WO_JOBS[JOB] = EARLIER ( WO_JOBS[JOB] ) &&
WO_JOBS[UNIT_NO]=EARLIER(WO_JOBS[UNIT_NO]) &&
WO_JOBS[UNIT_NO]=EARLIER(WO_JOBS[UNIT_NO]) &&
WO_JOBS[JOB_OPEN_DATE] < earlier(WO_JOBS[JOB_OPEN_DATE] )
),
WO_JOBS[JOB_OPEN_DATE], DESC
)
return
----DATEDIFF( minx(temp,[JOB_OPEN_DATE]),WO_JOBS[JOB_OPEN_DATE] ,DAY)
IF(ISEMPTY(temp),BLANK(),WO_JOBS[Meter_KM]-Minx(temp,WO_JOBS[Meter_KM]))
========================================================================
Please note: the three questions you answered were originally posted here as part of days difference question.
Thanks and best regards,
William