Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Count Of Days In Month.

Hi , Date                     hire date 05-Aug-2020       05-aug-19   I need how many months diffrence Date and hire date,please help on this issues.     Regards,
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    Anonymous , as new column

    datediff([hire date],today(),Month)

    or

    datediff([hire date],[date],Month)

     

    as a new measure // you need to take care of row context

    datediff(min([hire date]),today(),Month)

    or

    datediff(min([hire date]),Max([date]),Month)

Anand24's avatar
Anand24
Super User
6 years ago

Anonymous,

 

Create a new column and use the DATEDIFF function.

Here's a link to how DATEDIFF works: https://docs.microsoft.com/en-us/dax/datediff-function-dax

 

For months difference between Hire_Date and Date, you will have to use below formula:

Month_Diff Col = DATEDIFF([hire date], [Date], MONTH)

 

For days difference between Hire_Date and Date, you will have to use below formula:

 

Day_Diff Col = DATEDIFF([hire date], [Date], DAY)​

 

 

Give a thumbs up if this post helped you in any way and mark this post as solution if it solved your query !!!