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.
Solved! Go to Solution.
another quick way to convert DOB to age:
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.
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)
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))