Forum Discussion

Wresen's avatar
Wresen
Post Patron
6 years ago
Solved

Calendar Age between 2 dates

Hi and thanks for reading this.

 

I am trying to find a "correct" calender calculations for Age between 2 dates.

From what i can see "DATEDIFF('Table'[monthh];'Table'[Today];MONTH)" only changes Age when month changes , not taking the amount of days .

As you can see on the picture in yellow 69 days is still Age 2 but when we change month to 201912 it changes to Age 3

Is there any other way to calculate AGE between 2 dates ?

 

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Not sure if i understand correctly but you want the difference in days? In that case you can use this code:

    DATEDIFF('Table'[monthh];'Table'[Today];DAY)

     

    As you can see the last part of a DATEDIFF function is the interval.

     

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Not sure if i understand correctly but you want the difference in days? In that case you can use this code:

    DATEDIFF('Table'[monthh];'Table'[Today];DAY)

     

    As you can see the last part of a DATEDIFF function is the interval.

     

    • Wresen's avatar
      Wresen
      Post Patron
      6 years ago

      Hi Anonymous  and  amitchandak 

       

      I might run into a mind mine and did not think correctly 

       

      i think i will solve my "problem" with the measure Erichulshof posted 

      ROUNDUP(DATEDIFF('Table'[mont];TODAY();DAY)/30 ;0)
       
      /thanks