Forum Discussion
Continuous Membership Data Help
So I noticed the 'Date' table is not connected within the model.
There is no relationship tying it back to the 'SUBSCRIPTIONS' table (or any other table).
My understanding is that a relationship must exist.
But now I am confused how your [Members] measure is working, since it compares dates in the 'SUBSCRIPTIONS' table with dates in the 'Date' table.
Based on my limited experience, this should not be possible.
My apologies. I have never seen this before.
Perhaps someone with more expertise can assist here.
Regards,
Nathan
Yes The reason I dont have a relationship is because my date in the date field needs to work with the Original start date but also the end date - so didnt know how to relate both dates to the same date field. Therefore left it unrelated and it seems to work using the member measure I created.