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

[Anonymous]

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. 

[amitchandak]

@Anonymous , do you have some blank dates, remove them using a visual filter, also check are you taking sum or avg/

The measure should be coming from 'Recent Hires - NEO' table not the other one

[Anonymous]

@amitchandak There is no change if I filter out the blank dates. The time to hire is a column not a measure. It is averaged for the graphs.

[Anonymous]

@amitchandak My real question is how do I make a relationship that connects the Time to Hire column to the the date column so it can filter correctly? I have relationships between all the date columns but there are multiple.