Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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) )
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
98 | |
97 | |
81 | |
77 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |