Forum Discussion
mjholland
Advocate II
Advocate IICalculate Latest Start and Earliest Finish Time
Hi, My data has 2 columns - StartTime and EndTime - generated when an employee completes a visit to a customer. I need to use this information to work out the Earliest and Latest Start and Finish...
Nothing like a demo workbook to flush out an error :smileysurprised:
Try this
LatestStart = MAXX(values('Calendar'[Day]),CALCULATE(min(Data[Start Time])))
I missed the CALCULATE - sorry.
Here is the workbook demo https://www.dropbox.com/s/u6o1p0rpzuwnl4y/latest%20start.pbix?dl=0
MattAllington
Community Champion
Community ChampionNothing like a demo workbook to flush out an error :smileysurprised:
Try this
LatestStart = MAXX(values('Calendar'[Day]),CALCULATE(min(Data[Start Time])))
I missed the CALCULATE - sorry.
Here is the workbook demo https://www.dropbox.com/s/u6o1p0rpzuwnl4y/latest%20start.pbix?dl=0
mjhollandAdvocate II
Advocate IIYou had me thinking I was losing my mind there for a second.
This works perfectly. Thanks again for your help, and patience.
mjholland