Consider the following example. Dimension tables with information about users and groups. The startdate column indicates when the user/group was created. I want to analyze how many users and groups that were created in each month. I could either
A) Use only DAX without any relationship to the date dimension
B) Create inactive relationships as in alternative 1 and use USERELATIONSHIP
C) Create a factless fact table containing only the date information as in alternative 2. This is also what is done in the UserGroup example.
D) Create duplicate calendar table with a relationship only to the the user and group tables
Option C seems the “cleanest” to me but a bit of an overkill at the same time.
What’s your thought?