I have a few simple tables. One is Sales Budget by Customer and by Month (first day of the month). I have a Dates dimension table that was created from a DAX Function. I also have an aggregate of the Dates table by year and month, with Working days. This last table also lists the first day of each month.
Now, when I try to set up relationships between Budget and Dates, I can ONLY have a Many-to-Many relationship, EVEN THOUGH the Date column in the Dates table has no duplicate values. Same for a relationship from Budget to Working Days, again with the First day of each month being a unique value in Working Days.
If I try to swith relationships to One-to-Many or Many-to-One I am told that is not valid.
Why? In both cases I have a table with UNIQUE values.
Proud to be a Super User! |  |
Actually, I found the issue: I was merging my Date table with another table of dates that had duplicate dates, thus making the Date column NOT unique.
It's all about the data quality!
Proud to be a Super User! | |
Actually, I found the issue: I was merging my Date table with another table of dates that had duplicate dates, thus making the Date column NOT unique.
It's all about the data quality!
Proud to be a Super User! | |
Helpful resources
Power BI Monthly Update - November 2025
Check out the November 2025 Power BI update to learn about new features.
Fabric Data Days
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
