Get Max Date with Associated Value

[microwin88x]

Hello,

I have the following table, where Date format = DD/MM/YYYY:

Date	Curve A	Curve B
1/8/2017	26,62	26,97
2/8/2017	26,78	26,83
3/8/2017	26,63	26,80
4/8/2017	26,73	26,86
7/8/2017	26,35	28,05
8/8/2017	26,27	26,75
9/8/2017	26,80	28,05
10/8/2017	27,10	26,96
11/8/2017	27,35	27,47
14/8/2017	27,52	27,69
15/8/2017	28,34	25,69

What I need is to create a Textbox with Max value from Curve A (28,34) and Max value from Curve B (28,05).

Then, also create another Textbox with the associated Date for each Max value. Curve A = 15/8/2017 and Curve B = 9/08/2017 and 7/8/2017.

Do you know how to do that?

Thank you!!!

[sunny_talwar]

May be this

Concat(DISTINCT Aggr(If([Curve B] = Max(TOTAL [Curve B]), Date), Date), ', ')

and

Concat(DISTINCT Aggr(If([Curve A] = Max(TOTAL [Curve A]), Date), Date), ', ')

[Nicole-Smith]

These functions should work:

max([Curve A])	max([Curve B])	concat({<[Date]={'=[Curve A]=max(total [Curve A])'}>} Date, ', ')	concat({<[Date]={'=[Curve B]=max(total [Curve B])'}>} Date, ', ')
28.34	28.05	15/8/2017	7/8/2017, 9/8/2017

[sergio0592]

You can also achieve with :

=concat(date(if(aggr(rank(Curve_A,0,1)=1,Date),Date)),' , ')

and

=concat(date(if(aggr(rank(Curve_B,0,1)=1,Date),Date)),' , ')