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.
Ok, n00b here. My searching is weak so I didn't find anything that satisfied my need.
I have a dataset of work items. I have a lead time column present on each record. It is in minutes, and I want to create a measure that displays lead time in hours. I want that measure to be (in pseudo code):
lead time (hrs) = lead time / 60
I'm finding this difficult to do in DAX. What is your advice?
Solved! Go to Solution.
Hi @jugisahunk,
Please refer to below measure:
lead time (hrs) = SELECTEDVALUE(Dataset[lead time])/ 60
It does not work... I have a column of counts and need to divide ach value by a constant - this soln does not work
Hi @jugisahunk,
Please refer to below measure:
lead time (hrs) = SELECTEDVALUE(Dataset[lead time])/ 60
This gives me what I need :). Unfortunately, I'm getting an error when I try to accept this as a solution.
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 |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |