When linking my loans table to the dimDate table my years disappear. When I remove the relationship they come back. Anyone know why its doing this? I removed any summarization happening and still no luck. Any help would be appreciated.
I would suggest to set Caledar table Date column format to short date (18/11/2024) instead of (18/11/2024 00:00:00) and do the same for loan date by setting format to short date and i think it will work
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.