Create new measure instead of new column

[rachelbi]

Hi there, I have encountered a silly question which drag me for long time ... How to create a DAX measure instead of new column fron the table, as I want to know in each project , how much time have been spend in HOURS. I want the DAX measure for following calculation such as % completion. Thanks.

Note that in the table, each project id might have duplicate task id .. 

[jdbuchanan71 · Accepted solution]

@manvishah17 

You can do this with 2 measures.

The first one to add up the minutes.

Task Minutes = SUM ( 'YourTable'[Task Actual Time Minutes] )

The second one to format that duration into hh:mm format at whatever level it is viewed.

Task Duration (hh:mm) = 
 
VAR _Minutes = [Task Minutes]
VAR _Hours = INT ( DIVIDE ( _Minutes, 60 ) )
VAR _RemainingMinutes = MOD ( _Minutes, 60 )

RETURN
    IF (
        NOT ISBLANK ( _Minutes ),
            FORMAT ( _Hours, "00" ) & ":" & 
            FORMAT ( _RemainingMinutes, "00" )
    )

[manvishah17]

Hi @rachelbi , can you ellaborate more about from what you want to calculate hours and  completion %  or can you share sample dataset?