datetime to datetime relationship not pulling for visual

[joshcomputer1]

 I am struggling with the relationship between my date calendar and a date field in a table. Both are set to DateTime. I am able to draw the relationship without error. It is not being picked up when I use my date calendar date functions on the visuals.  What can I do to make this right?

* I have not used datetime fields before when relating tables so this is new to me. 

Here are the screenshots of the data type in both tables. a screenshot of the relationship being drawn. screenshot of visual not working right due to relationship.

[TomMartens · Accepted solution]

Hey,

using a calendar table is best practice 🙂

As you can see the date column from your calendar has a time part of 12:00 AM and the column from "fact table" has also a timestamp.

Create a new column in your fact table that just contains the date (data type date instead of date time, and relate the calendar table to this new column.

Problem solved 🙂

Regards,

Tom