Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

MAX help

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...
Need Help
Tutorial Requests
  • Vvelarde's avatar
    Vvelarde
    8 years ago

    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's avatar
waltheed
Impactful Individual
8 years ago

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])
	)