Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Date Relationship Issue

Hello,   I created a Calendar table using this expression: Date = CALENDAR(min(Recruitment[Hire Summary Date Range]),max(Recruitment[Hire Summary Date Range])) Then I created a many to one ...
Need Help
v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
8 years ago

Hi Anonymous,

 

Could you share a sample pbix file(with just some mock data) which can reproduce the issue, so that we can help further investigate on it? You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading. :smileyhappy:

 

Regards

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Thanks for the offer, but I have figured it out.

 

My "Hire Summary Date" column is a calculated column combining two date columns.  One of those columns is in the 'Date' format, the other is in 'Date Time" format.

 

I set the data type to 'Date' for this new calculated column, and created a relationship between it and the other column.  I don't understand why, but the values that originally came from a Date Time format were not finding a match through the relationship even though they were appearing as though they were in 'Date' format.

 

Once I changed the original column from 'Date Time' to 'Date' everything matched up through the relationship.  I would have thought that I could just change the Data type on the newly combined column.  I didn't think the original columns would matter.

 

Is there a difference between changing Data Type 'Date' and 'Date Time' via the Modeling tab vs in the Query itself?