Formula for "Minimum Date/Time Value in a Filtered List of Values"

I want to get the lowest/earliest Date value (data being a DateTime field), from the list where the “Custom Label” value is the same matching that for the current row.

I thought I could use the MIN function, but that does not seem to work for DateTime values.

MIN(SELECT(App Sheet Warehouse Locations[Date],[_THISROW].[Custom Label]=[Custom Label]),FALSE))

then I tried using SORT;

ANY(SORT(SELECT(App Sheet Warehouse Locations[Date],[_THISROW].[Custom Label]=[Custom Label]),FALSE))

though I get the same result, I see a DateTime value that is the “latest value” (also the row that is highest in the sheet)

Any ideas on how to achieve this?
Thanks,

Hi

Could you please try with following expression?

MIN(SELECT(App Sheet Warehouse Locations[Date],[_THISROW].[Custom Label]=[Custom Label]))

I believe the FALSE in the expression is not required.

I request @Steve or @Aleksi to change this post thread under “Questions” category.

1 Like