Calculating age from a date and time

[johnbradbury]

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).

I also have a seperate dataset with a start date and end date (date and time) which I need to calculate the days between the start and end.

[RayL]

FYI-

another quick way to convert DOB to age:

1. In Query Editor> select the column that contains DOB 
2. Go to Date & Time Colmn section > Date> Select "Age"
3. In Date & Time Colmn section > Duration > Select "Total Years"
4. Highlight the transformed column, right click and select "Change Type"> Select "Whole Number"
5. Rename the column

[AkshayManke]

What a Fantastic Way @RayL, Many thanks for Sharing.!

[sahibar]

I had similar requirement of calculating age from DOB. 

This is the easiest way to implement.

Thank you!!

[mplakin]

One issue with this method is that for anyone that is over 6 months into their "current" age, their age will be rounded up. E.g. 26.7 will be rounded up to 27.

The solution to this is before you convert the column to a whole number, instead right click on the column header and go to Transform -> Round -> Round Down.

[Vvelarde]

@johnbradbury

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]

Hello,

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

[chrisknox]

I used the Query Editor to "Insert a Custom Column" (Add Column tab).  I inserted the formula given here, but PowerBI doesn't seem to like the DATEDIFF function.  The system inserted the Table.AddColumn bit up to the DATEDIFF.

= Table.AddColumn(#"Removed Columns", "ItemAge", each DATEDIFF([FirstDetected],TODAY(),DAY))

 Advice welcome.

[johnbradbury]

Thanks you...

I seem to have done something wrong (assuming it's me as a newbie):

[Vvelarde · Accepted solution]

@johnbradbury

Use "New Column" not "New Measure"

[JimKingPowerBI]

Who wants an age in days? This is a silly solution!

[johnbradbury]

Thank you for taking the time to help me, it's much appreciated.

[MarcelBeug]

My best guess is that you need to choose "New Column" first.