Forum Discussion
Continuous Membership Data Help
Hi I need some help to identify if someone is a continuous member. I have a membership table with the following Member ID Original Start Date Start Date End Date Membership Type ID Memb...
Ah, ok. Well perhaps I can get you past the next step.
- You need multiple relationships between the 2 tables.
- Only 1 relationship can be active at a time. (Power BI requirement)
- The other relationship will be inactive.
- By default, the active relationship will be used.
- However, within a measure, USERELATIONSHIP can temporarily activate an inactive relationship.
- In the screenshot below,
- the solid line represents the default active relationship.
- the dotted line represents the default inactive relationship; which can only be made active within a measure which uses the USERELATIONSHIP function.
Hopefully this helps you get over the next hurdle.
Regards,
Nathan
Dind't know that one - very handy - ok will give that a try now.