Forum Discussion
Managing Multiple Relationships Between Tables
I have two data tables with several unique identifiers.
1. Company ID, (Note Company Names Differ)
2. Project Name and No
3. End Of Month
I have created a table to manage the Company ID
Linked the project tables directly with active relationship
When I try and merge the dates, it will not allow me to make the realtionship acitve.
I have tried a date table etc but cannot merge both tables together to create a common slicer.
Keeps saying there are ambiguous paths.
If I deactivate the project link then it will allow me to use months but not project names... very frustrating circle
Any ideas welcome
You can only have a single active relationship between two tables.
I would make a new calculated Date Dimension table using CALENDAR() that has an active many to one relationship to the date columns in both of those tables. Then use the [date] column in your new Date Dimension table for all visuals, filters, etc.
The proper syntax is something like this, my example only generates date from 2024-01-01 to 2024-12-31. You will want to choose a date range that is suitable for your needs.
Date_Table = CALENDAR(DATE(2024,1,1), DATE(2024,12,31))
4 Replies
A screenshot of your data model including all of the relevant tables would be very helpful in answering this question.
Thank you
You can only have a single active relationship between two tables.
I would make a new calculated Date Dimension table using CALENDAR() that has an active many to one relationship to the date columns in both of those tables. Then use the [date] column in your new Date Dimension table for all visuals, filters, etc.
The proper syntax is something like this, my example only generates date from 2024-01-01 to 2024-12-31. You will want to choose a date range that is suitable for your needs.
Date_Table = CALENDAR(DATE(2024,1,1), DATE(2024,12,31))
