Reply
Frequent Visitor
Posts: 2
Registered: ‎12-05-2018
Accepted Solution

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?


Accepted Solutions
Highlighted
Community Support Team
Posts: 5,429
Registered: ‎09-21-2016

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.

View solution in original post


All Replies
Highlighted
Community Support Team
Posts: 5,429
Registered: ‎09-21-2016

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.
Frequent Visitor
Posts: 2
Registered: ‎12-05-2018

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.