Forum Discussion
Writing Variable to get Last Gift Date and Amount
@ 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.
1 Reply
- Greg_Deckler
Community Champion
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
