I have data which has customer data and if applicable, member data.
Member is determined by if they have a member # so I first counted how many total members by counting Members with member # count(Members(Member#)
Then there is a need to find out of these members which ones are ACTIVE
-active is enrolled in the last 3 months OR a purchase within the last 18 months
I wasn’t sure how to do this so my process began as creating 2 conditional columns
Enrolled in last 3 months= IF(EDATE(‘Members’[Enrollment Date], 3)>TODAY(),1,0)
Purchase within 18 months = if(EDATE(‘Members’[Purchase Date], 18)>TODAY(), 1,0)
then I couldn’t figure out how to get that in it’s own measure with the operator OR.
(maybe there is another way besides using these too)
Active Member= Out of total members, how many are enrolled in last 3 months OR purchased within 18 months
Can someone help with this DAX?
thanks in advance