Date Hierarchy and Custom Column not Interacting Correctly - Time to Hire

Hello All,

I have two tables:

The first table is "job postings Neo" which has columns for "Job advertised from date", " Job advertized to date", "Job Name",  "ID" and some other information.

The second Table is  "Recent Hires - NEO" which columns for "Hired Date", "Job Posting ID", and some other information. 

I connect the tables using the job posting ID. I also connected both tables to a date table and made all the relation ships inactive.

I have created a column in the recent hires table called time to hire which has the following code:

Time to Hire = DATEDIFF(RELATED('jobpostings Neo'[advfrom]),'Recent Hires - NEO'[hiringperson.dthirestart],DAY)

 

This column graphs perfectly when using the "Advertised from date" but not when using the date heirarchy from my date table.

 

Here is what it looks like using the adversite from date:

 

Here is what it looks like using the heirarchy:

  

 

 

I would like the graph using the hierarchy to average the year, month, and week Time to Hire and display on a level higher than "date". Any help would be appreciated.