Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey All,
I'm looking for the first date with the max occupancy. The table with the input is;
Itemnr | Date | Occupancy |
---|---|---|
A | 1-1-2016 | 200 |
A | 2-1-2016 | 220 |
A | 3-1-2016 | 220 |
A | 4-1-2016 | 200 |
A | 5-1-2016 | 180 |
B | 1-1-2016 | 150 |
B | 2-1-2016 | 175 |
B | 3-1-2016 | 180 |
B | 4-1-2016 | 180 |
B | 5-1-2016 | 170 |
What I'm looking for is
Itemnr | Date | Occupancy |
---|---|---|
A | 2-1-2016 | 220 |
B | 3-1-2016 | 180 |
Function does work for itemnr with only 1 date with the max occupancy. Function so far is;
Firstsortedvalue(Date,-Aggr(sum(Occupancy),Date)
Hi Sunny,
In the above expression, I couldn't understand the below part alone
Date/1E6