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

Vvelarde's avatar
Vvelarde
Community Champion
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