Relationship from data set to date table works for one date and not another in with my measure

[leroy773]

All,

See other articles that relate to this issue, and attempted but still unable to display data based on date relationship.

I currently have a date table, the datekey is set to date/time.

I have a data set with two dates in it. 

One date is set to date and when I link this column to the date table my chart displays data, but bins it in the wrong qtr.  I attempted to link the correct date, which is in the format date/time.  When I do this my measure calculation does not display any data on my chart.  If I remove the date period, the data is displayed just in a blank column.  How can i ensure these date fields are linked correctly to show data.

The date installed field is a date and it works with date time field of the date key, but the Opened date does not.

[leroy773 · Accepted solution]

Even though my data type was correct, I noticed the data key also had hours.  They were all 12:00 am.  Since ny data set had different times, I believe that was the root cause since they did not match my calendar date table.  After removing time from the date field in the query it worked.