Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Issue with relationship between fact and datetable

Hi all,   I am quite experienced with SSAS and Power BI, but I have an issue with my date table, which was supposed to be straight forward.   I have 5 dimensions and 2 facts. All the relationship...
Need Help
  • richbenmintz's avatar
    richbenmintz
    9 years ago

    Have a look at your CalendarId column in the factInventorySnapshop View, they are not integer representations of dates, the Month portion is always 00, the join is correct however the data on the many side of the join does not match anything on the 1 side.

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Here is the pbix file - PBix file

 

Bests,

 

Line

richbenmintz's avatar
richbenmintz
Resident Rockstar
9 years ago

Have a look at your CalendarId column in the factInventorySnapshop View, they are not integer representations of dates, the Month portion is always 00, the join is correct however the data on the many side of the join does not match anything on the 1 side.

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    You are absolutly right. Thanks a lot ! :-)