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.

       

       

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

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

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