0
$\begingroup$

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 a Tableau user and am finding this difficult to do in Power BI. What is your advice?

Improve this question
$\endgroup$
1
  • $\begingroup$ If you are using a direct query, then here is a method: 1. Edit Query 2. In Power Query Editor find Add Column tab 3. Press Custom Column button 4. Here you can specify new column for example [lead time]/60 $\endgroup$
    – Levente Takács
    Dec 11, 2020 at 14:49

1 Answer 1

Reset to default
0
$\begingroup$

Ok, I got an answer from the powerbi community. Here it is:

lead time (hrs) = SELECTEDVALUE(Dataset[lead time])/ 60

I hope this helps someone.

Improve this answer
$\endgroup$

Not the answer you're looking for? Browse other questions tagged or ask your own question.