Forum Discussion
Establishing Relationship
Given this table:
How would I establish a connection to a date table? I'm unsure of which column you would use. I would need to be able to make a connection so I can determine things like active client counts and trailing 12 month retention formulas...
1 Reply
Hi mrainey ,
You can create a calendar table using calendar() function and then create a relationship between Calendar[Date] and YourTable[Start Date] or YourTable[End Date], which date column to be used as a related column with calendar table depends on your requrement. To create relationship between two tables, click Manage Relationships.
Regards,
Jimmy Tao
