Forum Discussion
Date relationship problem
Get rid of the many-to-many, they are evil, make things not work properly and are almost always avoidable. Implement a bridge table of unique key values.
OK, let's back up, what are we trying to do here overall? Take a look at what I did with your date table (Table) and the Model. Use your dimension tables like your calendar table and bridge table to affect both of your fact tables.
Attached below.
hi Greg_Deckler
I realized that my relationship model is not so good, and you confirmed me that by avoiding many to many relationships. In fact im havind some issues creating dax, so I need to get this relations set properly.
I checked your solution and found out that for example when i select a brand, the code wont filter at all:
For example for CR I have the following codes for that brand:
I did a table with the code + column date of formula and another table with code + date of query1 and didnt work well:
https://1drv.ms/u/s!ApgeWwGTKtFdhks4LrGKQB-RfqCQ?e=tQFLfi
Appreciate your help!