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
    9 years ago

    Thanks you...

     

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

     

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

      Anonymous

       

      Use "New Column" not "New Measure"

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

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

         

         

    • MarcelBeug's avatar
      MarcelBeug
      Icon for Community Champion rankCommunity Champion
      9 years ago

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

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

  • 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?