Return value based on min from different column

[#1]

Hi all,

let's say I have a table:

Item (key)	Quantity	Delivery
12345	10	1.12.2016
12345	50	5.12.2016
23456	30	15.12.2016
23456	5	3.12.2016

I need to select data per Item from Quantity column where Delivery is lowest.

Target is to get following in chart table:

Item	Quantity	Delivery
12345	10	1.12.2016
23456	5	3.12.2016

Is it possible via set analyses or something, or do I have to prepare the data in script, using for example mapping?

Select lowest Delivery is simple, but how do I return data from different column once I found lowest date?

Following shows script error:

only({<[Delivery]={min([Delivery])}>},Quantity)

[marcus_sommer]

Try it with: firstsortedvalue(Quantity, -Delivery) where Delivery must be a real date respectively numeric.

- Marcus

[sunny_talwar · Accepted solution]

Just a slight modification. If you want this based on minimum value of delivery, I would not use -Delivery

FirstSortedValue(Quantity, Delivery)

[MK_QSL]

For 23456 MinDate mentioned is 3.12.2015 Which is not in Source Data.. !!

[sunny_talwar]

Hahahahaha good one

[#6]

Thank you, I updated it

[#7]

Thank you for the hint