get date of maximum value

[jeevays7]

Hi all,

I have data like below.

Date	Month	Value
1-Jan-17	Jan	2
2-Jan-17	Jan	3
3-Jan-17	Jan	4
4-Jan-17	Jan	5
2-Feb-17	Feb	3
3-Feb-17	Feb	2
4-Feb-17	Feb	4
5-Feb-17	Feb	5
1-Mar-17	Mar	8
2-Mar-17	Mar	2
3-Mar-17	Mar	1
4-Mar-17	Mar	4

from above table i need the max value of each month and the date of the max value of the month.

output table is below:

Month	Max Value	Date
Jan	5	4-Jan-17
Feb	5	5-Feb-17
Mar	8	1-Mar-17

Please suggest me.

[sunny_talwar · Accepted solution]

May be this

Dimension

Month

Expression

Max(Value)

FirstSortedValue(Date, -Value)