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) )

Anonymous's avatar
Anonymous
Not applicable
5 years ago

mbailey 
You cannot just refer to a column in a measure, you must add a function to refer to a column value. In your case, using min, max, sum, average, selectedvalue, are all the same they just call out the current row of the [install_date].

 

 

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.