Forum Discussion
Colander Table With Two Date Replationship
Hello, i have a calendar table linked to another table called "Total" via a column called Received date.
On some pages of my report, I want to use another date column from the "Total" Table. This column is called "Completion date".
i am not sure how to handle this as there is only one active connection allowed, do I have two calendar tables. should I split out all the completions from the "Total" table.
Thank you
You dont need a second date table. Instead, in this scenario, you create two relationships.
1) Active
2) Inactive.
Where ever you need to use the inactive relationship, you can use Userelationship DAX Function
2 Replies
You dont need a second date table. Instead, in this scenario, you create two relationships.
1) Active
2) Inactive.
Where ever you need to use the inactive relationship, you can use Userelationship DAX Function
Check out this tutorial below.
