Forum Discussion

mbailey's avatar
mbailey
Icon for Helper II rankHelper II
5 years ago
Solved

Can't create datediff measure

Hi,   I've got a table with a date field in it called install_date. The field is of Type Date: I'm trying to create a measure to calc the number of days between this date and Today usi...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    mbailey , you can create a column like that.

    For measure, you have to use min/max.

     

    or

     

    Try like

    Averagex(Table, datediff([Install Date], today(), day) )

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

mbailey , you can create a column like that.

For measure, you have to use min/max.

 

or

 

Try like

Averagex(Table, datediff([Install Date], today(), day) )