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.

v-zhangti's avatar
v-zhangti
Community Support
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.