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

9 Replies

  • Phil_Seamark's avatar
    Phil_Seamark
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    Hi eOfer

     

    What would your expected result be for the top row where Subscriber is 0528889991?

    • eOfer's avatar
      eOfer
      New Member
      8 years ago

      Hi Phil_Seamark,

      The aim of my question is to show a tendency of active subscribers per chosen period.

      If 0528889991 is within the chosen period - count it and display on the graph.