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 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-False-expression/m-p/3761019#M1219987

Need Help

2 Replies

  • 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.