cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Super User
Super User

Re: Calculate Latest Start and Earliest Finish Time

Your not being a pest.  Let's just get it sorted :-)

 

The issue is you have VALUES(calendar[date]).  Look back at my formula - it uses DAY, not DATE.  the Day column in your calendar table should have Sun, Mon, Tues etc


Give me 5 mins and I will post a sample workbook for you

* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
Super User
Super User

Re: Calculate Latest Start and Earliest Finish Time

Nothing like a demo workbook to flush out an error Smiley Surprised

 

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

* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
Highlighted
mjholland Regular Visitor
Regular Visitor

Re: Calculate Latest Start and Earliest Finish Time

You had me thinking I was losing my mind there for a second.

This works perfectly. Thanks again for your help, and patience.

 

mjholland