Forum Discussion

shaima97's avatar
shaima97
Frequent Visitor
3 years ago
Solved

DATEDIFF not recognizing a column

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" col...
Need Help
  • v-zhangti's avatar
    v-zhangti
    3 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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