Forum Discussion
Cardinality Issue
Hi, I am trying to create relationship between Calendar_Date (1/1/2000 - 12/31/2020) and admission_date column. Admission_date column has repeatitive dates, as many person can take admission on same day. But Calendar_Date has unique values only. But still I am not able to create Many to one relationship. Power BI is automatically detecting it as Many to Many, and won't let me change it. Please help!
Anonymous,
Column 'Calendar_Date' contains blank values and this is not allowed for columns on the one side of a many-to-one relationship.
3 Replies
Try deleting the relationship and re-creating it manually.
Anonymous,
Column 'Calendar_Date' contains blank values and this is not allowed for columns on the one side of a many-to-one relationship.
