Calendar Age between 2 dates

[Wresen]

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 ?

[amitchandak]

What it should have displayed?

[Wresen]

Hi @EricHulshof  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

[EricHulshof · Accepted solution]

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.