I need help with connecting the data tables correctly.
There is a data model that includes a single fact table with 3 important date fields. A link table was created for the date fields, and this table links the fact table to the calendar. In the UI sheets, the user needs to choose which date field they want to view data by, and it's worked fine.
Now I need to add 3 more fact tables to the model. I’m thinking of linking the tables using a key table, but I’m unsure how to handle all the date fields because I want to link all of them to a single calendar table, rather than creating a separate calendar for each field.
Here are the tables and the main fields that I thought of adding to the key table: * Plans table (exist table) - PlanID, CreateDate, ExecuteDate, CloseDate, ManagerID. * Plans Lines table - PlanID, LineCreateDate, LineCloseDate. * Incidents table - PlanID, IncDate. * Managers table (each manager in each date) - ManagerID, Date.
The idea was to link all the dates to a shared calendar with a specific tag, and then in each measure, I can define the relevant tag. For example, Number of Incidents for a Plan = (Number of Incidents by IncDate) / (Number of Plans by CreateDate or ExecuteDate).
I would appreciate their help on this issue. Thanks.
.png "Former Employee"){kind=icon}
