DATEDIFF not recognizing a column

[shaima97]

Hello everyone , 

im trying to calculate the probation period of the employees

the probation period is the employees that their haring date is 3 months or less.   

i have a "hiring_date" column , and im geeting my table data from sql server . 

i used to do this dax fourmula with other projects that have data from an excel sheet , but its not working with my new project ,

this my old project the data is from an excel sheet :

 when i do it with my new project it show me this error :

 

i need help please . 

thank you 

[Anonymous]

Hi, 

If there are two values in the hiring_date column that are the same, the measure will only return a value for one of them, How do we update the formula so it brings back values for all?

Thanks 

[v-zhangti · Accepted solution]

Hi, @shaima97 

You can try the following methods.
Column:

Column = DATEDIFF([Hiring_date],TODAY(),MONTH)

Measure:

Measure = DATEDIFF(SELECTEDVALUE('Table'[Hiring_date]),TODAY(),MONTH)

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Greg_Deckler]

@shaima97 In your image, I do not see any other columns in your table.