Cardinality Issue

[Anonymous]

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!

[RMDNA]

Try deleting the relationship and re-creating it manually.

[Anonymous]

Still not working, I will appreciate any insight on this!

[v-chuncz-msft · Accepted solution]

@Anonymous,

Column 'Calendar_Date' contains blank values and this is not allowed for columns on the one side of a many-to-one relationship.