Date Hierarchy not applying to all dates

[Hesherkid]

Hello, 

I have created a custom rolling_calendar table and have a relationship to my other table ChildJobs which has dates coming in from JobFinishDates. I put together a table using my JobFinishDates date and rolling_calendar date hierarchy and it isn't applying to all the dates. When I change the relationship from childjobs to jobfinishdates it behaves the same. 

I created measures to make so that my dates are inline and they are, I've confirmed that the format for all date columns is the same. 

[ToddChitt · Accepted solution]

You have values displayed that include a TIME element. Therefore I kind of assume that it is a Date/Time data type. 

 I don't care about formatting. I care about data TYPE. You can have a DATE/TIME data time and value of "1-Jan-22 12:34PM" but then FORMAT it as a DATE so it shows up and is displayed as "1-Jan-22". But under the covers that time element is still there. And any TIME other than 12:00 AM will NOT match to a pure DATE data type.

What are the DATA TYPES of the columns?

[Hesherkid]

Thank you ToddChitt for having me review those, the table that I am Splitting into the ParentJob and ChildJob had DATE/TIME where my ChildJobs, and JobFinishDates had DATE and that was the issue. Much appreciated 

[ToddChitt]

Can you show us some sample data from both the custom rolling dates table, and the table it is related to?

Can you verify that 4-Oct -22 is or is not in the dates table. 

Are both columns in the relationship actual DATE types (hint: i.e.: NOT date/time fields with a date format)?

[Hesherkid]

Rolling_Calendar

ChildJobs table

JobFinishDates related to ChildJobs

I created Measures to confirm the date ranges are covered. 

All Date columns in all tables are formatted as 

Thanks,