Forum Discussion

ltilley's avatar
ltilley
Regular Visitor
8 years ago

Second Last Transaction Date without filters

Hi,   I work at a nonprofit with specific KPIs for donors based on the length of time between their two previous donations. We categorize donors in the following ways: Active donors: last transac...
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
8 years ago

Hi,

 

Try this

 

VAR LastTransDate = MAX(Transactions[transaction_date]) RETURN CALCULATE( MAX(Transactions[transaction_date]), FILTER(Transactions[transaction_date] < LastTransDate),ALLEXCEPT(Transactions,Transactions[transaction_date],Transactions[Donor]) )

 

ltilley's avatar
ltilley
Regular Visitor
8 years ago

I tried that and based on the documentation available for ALLEXCEPT, it seems like that should work, but when I tried it on my data, it didn't work.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    8 years ago

    Hi,

     

    Share the link from where i can download your file.