I’m trying to source the last donation date and second last donation date from the Donations (sales) table to the Pledges table (which has unique Customer IDs) using calculated columns.
I managed to source the last donation date using the formula of:
Last Donation Date = MAXX( FILTER( ALL( Donations ), Donations[Customer ID] = Pledges[Customer ID] ), Donations[Donation Date] )
However I’m struggling to create the column with the second last donation date.
Any suggestions would be much appreciated.