Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
@ryand009 Can you just edit the relationship by double-clicking it and change it to 1:M?
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?
User | Count |
---|---|
97 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
112 | |
96 | |
95 | |
67 | |
65 |