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,
User | Count |
---|---|
37 | |
26 | |
23 | |
17 | |
14 |