Skip to main content

Notifications

Power Up Program - Visualize data with Power BI
Suggested answer

Relationships

Posted on 17 Nov 2024 21:21:39 by
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. 
Categories:
  • Suggested answer
    kasraouiah Profile Picture
    kasraouiah 176 on 18 Nov 2024 at 04:06:13
    Relationships
    Hello,
    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.

Helpful resources

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,151

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,845

Leaderboard

Featured topics