Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Calculating age from a date and time

I'd be extreemly grateful if someone could help with this. I have a column containing date and time information. From this I need to create a new column which shows the age based on the date (in days...
Need Help
  • Vvelarde's avatar
    Vvelarde
    9 years ago

    Anonymous

     

    Use "New Column" not "New Measure"

Vvelarde's avatar
Vvelarde
Icon for Community Champion rankCommunity Champion
9 years ago

Anonymous

 

hi,

 

To calculate the age in Days:

 

Age = DATEDIFF(Table1[DateTimeColumn],TODAY(),DAY)

 

to calculate the days between the start and end.

  

DaysBetween = DATEDIFF(Table1[StarDate],Table1[EndDate],DAY)

jdubs's avatar
jdubs
Icon for Helper V rankHelper V
1 year ago

Hello,

 

If I then wanted to create a measure of the AVERAGE of all the "ages" how would I achieve this?