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

Bridge Table = 

  DISTINCT(

    UNION(

      SELECTCOLUMNS('Query1',"Merged",[Merged]),

      SELECTCOLUMNS('Formulas',"Merged",[Merged])

    )

  )

 

Zero maintenance required.

      

o59393's avatar
o59393
Post Prodigy
6 years ago

hi Greg_Deckler 

 

Here it is:

 

 

But the values are still not filtering correctly:

 

 

thanks!

  • 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.