Forum Discussion

Youssef_Hamed's avatar
Youssef_Hamed
New Member
2 years ago
Solved

Relationship Issue Between Year Dimension and Fact Table

Description: I created a year dimension table with distinct years and linked it to the year column in my fact table. The relationship doesn’t work unless I set the cross-filtering option to "Both." ...
Tips and Tricks
  • Youssef_Hamed's avatar
    Youssef_Hamed
    2 years ago

    Hello Ashish,

    Thank you for your helpful response!

    I believe the issue might be that when I tried creating the calendar table, the relationship setup window was too large, hiding the "Save" and "Cancel" buttons at the bottom. As a result, I may have mistakenly selected the wrong option while navigating with the Tab key.

    Do you happen to have a solution for resizing or adjusting the window so that all options are visible?

    I’ll give it another try following your advice.

    Thanks again for your guidance!

    Best regards,
    Youssef Hamid

audreygerred's avatar
audreygerred
Icon for Super User rankSuper User
2 years ago

I use this date table from SQLBI and love it! Once you get this in your model you can join to the date in your fact table and then filter on year from the dim table (and do any of the time intelligence measures you may need). DAX Date Template - SQLBI