Forum Discussion

Julier's avatar
Julier
Icon for Helper III rankHelper 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 sh...
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.

lbendlin's avatar
lbendlin
Icon for Super User rankSuper 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
Icon for Helper III rankHelper 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?