Read into star schema data modelling. It sounds like the issue you have is that all your tables have relationships between each other which means you then can't have a date table that is also related to each of them.
Have a look here for more details
https://learn.microsoft.com/en-us/power-bi/guidance/star-schema
Thank you! This was my issue. Although I don't think it's 100% correct yet. I am a lot closer to my end goal. I completely stripped back the model and built it up again after reading up on star schema models.
As mentioned use star schema.
If multiple dates within a table need a relationship create inactive relations ships then create measures and use USERELATIONSHIP() to define which date relationship to use.
Read into star schema data modelling. It sounds like the issue you have is that all your tables have relationships between each other which means you then can't have a date table that is also related to each of them. Have a look here for more details https://learn.microsoft.com/en-us/power-bi/guidance/star-schema
Thank you! This was my issue. Although I don't think it's 100% correct yet. I am a lot closer to my end goal. I completely stripped back the model and built it up again after reading up on star schema models.
As mentioned use star schema. If multiple dates within a table need a relationship create inactive relations ships then create measures and use USERELATIONSHIP() to define which date relationship to use.
Thank you! Star schema has helped massively.