Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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 relationship between "Date" and "Hire Date Summary Range".

However, there are a handful of dates in the "Hire Summary Range" column that do not return a corresonding value from "Date", even though the dates DO exist in the "Date" column.  I can't seem to figure what is special about these dates which would cause this to happen.  Hoping someone has an idea I can work with to troubleshoot.


2018-01-17_10-36-27.png           >>>>>>>>    2018-01-17_10-38-38.png

2 REPLIES 2
v-ljerr-msft
Employee
Employee

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 uploadingSmiley Happy

 

Regards

Anonymous
Not applicable

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?

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.