Forum Discussion

ryand009's avatar
ryand009
Frequent Visitor
2 years ago

PBI creating incorrect relationship

Hello.

 

I'm creating a non active relationship from my Canendar table to a date on my Catalog table (see below). Problem is PBI is automatically creating a 1:1, when it s definitely a 1:M relationship. Thre are multiple occurances of the same date in Catalog. Both attributes are Date types, formatted as dd/mm/yyyy

Not sure why this is happening and its producing some odd values in measures?

 

Any advice, gladly accepted.

 

 

Thanks in advanve

Ron

 

 

 

 

Need Help

2 Replies

  • CoreyP's avatar
    CoreyP
    Icon for Solution Sage rankSolution Sage
    2 years ago

    This was happening to me just yesterday. I was only using sample data with three rows, but it was because there were not multiple values of the same date in the fact table. When I made two rows have the same date value, it allowed the 1:*. Are you certain your catalog table has multiple of the same date value?