Forum Discussion

Julier's avatar
Julier
Helper III
2 years ago
Solved

Relationships cardinality

Hello i am trying to link the two tables below by account id, but keep getting them message regarding cardinality and i am unable to find a link that works to allow me to build a combination chart showings sales against forecast

 

Need Help
  • Julier's avatar
    Julier
    2 years ago

    Thanks for this, I'm sure that this works but I  am still unable to undersatnd how to do it thats just my weakness with power bi, i will give up on trying to do this but will accept that this is probably the solution.

12 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    You are missing the Calendar table that acts as a controlling dimension for your two independent fact tables. Don't link fact tables with each other.

  • Julier's avatar
    Julier
    Helper III
    2 years ago

    Hello, thank you, have trried this but no luck is there anyrhing else that i must have missed?

     

    • johnbasha33's avatar
      johnbasha33
      Super User
      2 years ago

      Julier  as suggested by lbendlin  you need to use calender table to join them. 

      Calendar = CALENDAR(MIN('YourStartDateColumn'), MAX('YourEndDateColumn'))

      Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!

  • Julier's avatar
    Julier
    Helper III
    2 years ago

     have added the calendar but no luck, I have added  a chart which shows SQM for each site by date but i needed to add the monthly S&OP for each site i have tried everything but no luck 

     

    • lbendlin's avatar
      lbendlin
      Super User
      2 years ago

      In your S&OP table create a fake date column (for example first day of the month).  Then join the tables via the date.

      • Julier's avatar
        Julier
        Helper III
        2 years ago

        Hi,  i have done this and i can bring in the S&OP but its the same figure for each and every account ID, it does not change as it should?