MAX help

[Anonymous]

Hello Community. 

I have a table like this

Shares	Date
1	01/02/2003
2	02/02/2003
4	03/02/2003
5	04/02/2003
3	05/02/2003
47	06/02/2003
1	07/02/2003
54	08/02/2003
756	09/02/2003
1	10/02/2003
2	11/02/2003

I need to find the date when the max shares is located using DAX. Help please.

Thank you.

[Vvelarde · Accepted solution]

@Anonymous

Hi, you can obtain in a card using this measure:

Measure =
VAR MaxShare =
    MAX ( Table1[Shares] )
RETURN
    CALCULATE ( MAX ( Table1[Date] ); Table1[Shares] = MaxShare )

Regards

Victor

[waltheed]

Is this what you mean?

This is the dax expression:

Max Shares Date = 
	calculate(
		MAX(Table1[Date]),
		FILTER(Table1,Table1[Shares] = MAX(Table1[Shares])),
		ALL(Table1[Date])
	)