cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jugisahunk Frequent Visitor
Frequent Visitor

How to Divide Measure by Constant

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?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support Team
Community Support Team

Re: How to Divide Measure by Constant

Hi @jugisahunk,

 

Please refer to below measure:

lead time (hrs) = SELECTEDVALUE(Dataset[lead time])/ 60
Best regards,
Yuliana Gu
Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
Highlighted
Community Support Team
Community Support Team

Re: How to Divide Measure by Constant

Hi @jugisahunk,

 

Please refer to below measure:

lead time (hrs) = SELECTEDVALUE(Dataset[lead time])/ 60
Best regards,
Yuliana Gu
Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
jugisahunk Frequent Visitor
Frequent Visitor

Re: How to Divide Measure by Constant

This gives me what I need Smiley Happy. Unfortunately, I'm getting an error when I try to accept this as a solution.