Forum Discussion

o59393's avatar
o59393
Post Prodigy
6 years ago
Solved

Date relationship problem

hi all   I have 2 tables, both contain a day by dat date column in yyyy-mm-dd format.   There is a code asociated with each of the days. Code SP/B-0144.11 starts on 2/15/2019, while SP/B-0171.00 ...
Need Help
Show and Tell
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago

    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.

Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago

Try making the relationships Both direction

o59393's avatar
o59393
Post Prodigy
6 years ago

it's not showing left table and right table will not show only 2019.

 

Thanks again!

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    6 years ago

    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.

     

    • o59393's avatar
      o59393
      Post Prodigy
      6 years ago

      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!