Forum Discussion
Helper I2 tables with Different dates
No, you should link them on the Date field, so that it is a one-to-many relationship from Date to each of the other tables.
You can make both relationships inactive, so as to not interfere with the current relationship, and then use USERELATIONSHIP in your calculations.
It is not best practice to have many-to-many relationships, that can make for some very complicated DAX and some unexpected behaviours. It might be worth looking at changing your main relationship to one-to-many, possibly by building a bridge table between the two.
Helper IThank you for your Qucik response ! however creating 2 relationships to a Date table will automatically disable on of the relationships , created a date table and connected them on the Month as seen below not sure if this is best practice
Super UserNo, you should link them on the Date field, so that it is a one-to-many relationship from Date to each of the other tables.
You can make both relationships inactive, so as to not interfere with the current relationship, and then use USERELATIONSHIP in your calculations.
It is not best practice to have many-to-many relationships, that can make for some very complicated DAX and some unexpected behaviours. It might be worth looking at changing your main relationship to one-to-many, possibly by building a bridge table between the two.