Forum Discussion
Managing Multiple Relationships Between Tables
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))
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.