Writing Variable to get Last Gift Date and Amount

[Anonymous]

@ links to members, content

I am new to writing variables in Power BI.  I have a report with multiple dates and amounts.  I would like to see the very last date for a cutomer gave with the amount.   Here is my table: 

My report should only show the 3/10/2022 date and amount.   Here is my variable:

Last Gift Date3 =

    VAR MxDate = SelectedValue('hopedb hmg_gift'[gift_date_natural])

Return

    MAXX(

        Filter(ALL('hopedb hmg_gift'),'hopedb hmg_gift'[gift_date_natural] = MxDate),

            'hopedb hmg_gift'[amount])

I am not sure what is wrong with my variable.

[Greg_Deckler]

@Anonymous So, assuming that there is some column in your table visual like "Customer", then you could try a couple measures like this:

Last Gift Date Measure = 
  VAR __Customer = MAX('hopedb hmg_gift'[Customer])
  VAR __Return = MAXX( FILTER( 'hopedb hmg_gift', [Customer] = __Customer ), [gift_date_natural])
RETURN
  __Return


Last Gift Amount Measure =
  VAR __MaxDate = [Last Gift Date Measure]
  VAR __Return = MAXX( FILTER( 'hopedb hmg_gift', [Customer] = __Customer && [gift_date_natural] = __MaxDate ), [amount])
RETURN
  __Return