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

Watsky's avatar
Watsky
Icon for Solution Sage rankSolution Sage
5 years ago

Hey mbailey,

 

amitchandak  is correct since you're doing a measure there needs to be some sort of aggregator.  Another option you can try is using SELECTEDVALUE

 

 InstallDays =  DATEDIFF(SELECTEDVALUE('DMTA_Service_Install_Base'[install_date]),TODAY(),DAY)

 


Did my answer(s) help you? Give it a kudos by clicking the Thumbs Up! ?
Did my post answer your question(s)? Mark my post as a solution. This will help others find the solution.