Card - Show the last value according to date

[EsterBR]

Hi,

I have the following table and I would like to add a card to the dashboard the shows the latest value in the table according to the last date. In this case the card should show 403. How can I achieve this?

Thank you so much!

[bchager6 · Accepted solution]

@EsterBR  This should work:

Sales for Most Recent Date =
VAR MaxDate =
    MAX ( 'Table'[Date] )
RETURN
    CALCULATE ( SUM ( 'Table'[Sales] ), 'Table'[Date] = MaxDate )