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

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 !!