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)

Anonymous's avatar
Anonymous
Not applicable
6 years ago

 

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.