Minimum values filtered between dates

[hayden]

I'm trying to create a measure to calculate the minimum of a set of values but only for values between two dates. The start and end date are measures. On in my table of data, and one in another table.

=CALCULATE(min(DailyTable[Gross+Ralston]),filter(DailyTable,DailyTable[Date]>=MaxPct[CriticalStartDate] && DailyTable[Date]<=[CriticalEndDate]))

Can anyone help me understand how to do this?

 

[hayden]

Well, a walk outside and more googling resulted in this:

Measure 1:=VAR startdate=MaxPct[CriticalStartDate] var enddate=[CriticalEndDate] return CALCULATE(min(DailyTable[Gross+Ralston]),DailyTable[Date]>=startdate&&DailyTable[Date]<=enddate)

I guess I need to read up on the FILTER command as its missing from this...

 

[hayden]

But now I need to find the date that this minimum occurred. Can you pass a filtered list to Lookupvalue?