Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
JCDaling06
Regular Visitor

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

2 REPLIES 2
Ashish_Mathur
Super User
Super User

Hi,

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


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
lbendlin
Super User
Super User

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.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors