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)

Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago

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)