Date table relationships with other tables

[MontherKH]

I have a question regarding the following 3 tables which appear in the image below:

- Resources table (It contains a date field ("hire_date").

- ProductsResources table (it contains two date fields ("start", "end").

- Date table (Generated from CALENDARAUTO function)

As you can see, the relationship between the Date and ProductsResources tables is inactive, also this inactive relationship is only between the "date" and "end" fields, I can't create a relationship between the "date" and "start" fields.

I have the two visualizations below which show that the date table works correctly only with the Resources table (the one on the right).

What should I do instead to make everything works?

[darkinvader_]

Hi @MontherKH ,

you can use USERELATIONSHIP formula which will utilise your inactive relationship when that measure will run.
Could you please specify what you need so that I can provide you with a solution.

Please do gives a thumbs up if it helps you

Regards
Dark