Display the most recent value in a card

[jamieham]

I'm trying to display the most recent value in a card but cant seem to get it to work correctly.

I have different individuals who have had their weight, skinfolds etc measured on different days and I want the cards to display the most recent scores for weight, skinfolds etc. 

For example if I selected Player 1 his cards would display:

Weight  124.54

Skinfolds 79.21

Name.     Date Tested.      Weight.        Skinfolds

Player 1.     12/3/2020.      123.               75.32

Player 2.     24/4/2020.      98.67             43.21

Player 1.     20/4/2020.      124.54.              -

Player 2.     15/1/2020.      96.90               45.00

Player 1.      1/5/2020.           -                  79.21

[amitchandak · Accepted solution]

@jamieham , Try measure like

last Weight = LASTNONBLANKVALUE(Table[Date Tested], max(Table[Weight]))

last Skinfolds = LASTNONBLANKVALUE(Table[Date Tested], max(Table[Skinfolds]))