Donor Re-engagement

[JCDaling06]

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 2024.  All the dates are 

Re-engagement measure = 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))) return COUNTROWS (_table)+0

This post got me nearly all the way there- but I am getting the error message "return is not correct syntax".  Any ideas?  I dont often use DAX so I apologize if this is an obvious answer.  

https://community.fabric.microsoft.com/t5/Desktop/A-function-DATESBETWEEN-has-been-used-in-a-True-Fa...

[Ashish_Mathur]

Hi,

Share data in a format that can be pasted in an MS Excel file.

[lbendlin]

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.