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

[Tom_Graham]

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,

[Suvrutt_Gurjar]

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.