Count Of Days In Month.

[Anonymous]

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,

[amitchandak · Accepted solution]

@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]

@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 !!!

[az38]

Hi @Anonymous 

try new column

Column = DATEDIFF([hire date], [Date], MONTH)

[Greg_Deckler]

@Anonymous - Maybe:

Column =
  VAR __HireYear = YEAR([hire date])
  VAR __HireMonth = MONTH([hire date])
  VAR __DateYear = YEAR([Date])
  VAR __DateMonth = MONTH([Date])
RETURN
  (__DateYear - __HireYear)*12 + (__HireMonth - __DateMonth)