Forum Discussion

JCDaling06's avatar
JCDaling06
Regular Visitor
2 years ago

Donor Re-engagement

Hello!   I need help making a formula or series of formulas that can provide me with a distinct count of user ID that donated in FY 2024, did not donate in FY 2023 AND donated any time prior to FY 2...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago
Re-engagement measure = COUNTROWS(CALCULATETABLE('Table1', DATESBETWEEN(Table1[Gift date],DATE(2023,07,01),DATE(2024,06,30)), NOT(DATESBETWEEN(Table1[Gift date],DATE(2022,07,01), DATE(2023,60,30))), DATESBETWEEN(Table1[Gift date],DATE(1980,01,01), DATE(2022,06,30))))

 

Personally I would use EXCEPT and INTERSECT instead.