Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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 using this formula, but it errors saying it can't find the field. When building the formula, it only wants to suggest fields that are existing Measures and I can't pick any other fields.
What am I missing?
Thanks,
Mike
Solved! Go to Solution.
@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) )
@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.
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)
Proud to be a Super User!
@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) )
User | Count |
---|---|
64 | |
59 | |
47 | |
33 | |
32 |
User | Count |
---|---|
84 | |
75 | |
56 | |
50 | |
44 |