Forum Discussion

eOfer's avatar
eOfer
New Member
8 years ago
Solved

Add DATESBETWEEN measure based on 2 date columns

Hi, How do i add a Subscriber measure based on valid dates per period between Effective_Date and Expiration_Date? Thanks!  
Show and Tell
  • eOfer's avatar
    eOfer
    8 years ago

    Thanks a lot Phil_Seamark!

    Awesome!

eOfer's avatar
eOfer
New Member
8 years ago

Thanks a lot Phil_Seamark!

Awesome!

eOfer's avatar
eOfer
New Member
8 years ago

Hi Guys,

I'm trying to figure out from the table how many active subscribers do i have between start date (Effective_Date) and present day, considering their formal end date (Expiration_Date). 

Any thoughts will be much appreciated!

Thanks,

Ofer Eavri

Active Users