Forum Discussion

ToddChitt's avatar
ToddChitt
Icon for Super User rankSuper User
8 years ago
Solved

Forced into many to many relationship

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...
  • ToddChitt's avatar
    ToddChitt
    8 years ago

    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!