Forum Discussion

jugisahunk's avatar
jugisahunk
New Member
7 years ago
Solved

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?

Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    7 years ago

    Hi jugisahunk,

     

    Please refer to below measure:

    lead time (hrs) = SELECTEDVALUE(Dataset[lead time])/ 60
    Best regards,
    Yuliana Gu

3 Replies

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    7 years ago

    Hi jugisahunk,

     

    Please refer to below measure:

    lead time (hrs) = SELECTEDVALUE(Dataset[lead time])/ 60
    Best regards,
    Yuliana Gu
    • jugisahunk's avatar
      jugisahunk
      New Member
      7 years ago

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

  • Yosi's avatar
    Yosi
    Frequent Visitor
    3 years ago

    It does not work... I have a column of counts and need to divide ach value by a constant - this soln does not work