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" 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 

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.

3 Replies

  • 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.

  • 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