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 A...
  • 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.