Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Hours Expended Based on Conditions

Hello,   I want to calculated hours expended in my dataset based on a few conditions.   Example Dataset  ID Crew Size Time Delta Start / Finish Job Type (Erect or Dismantle) 1 3 1 S...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • tamerj1's avatar
    tamerj1
    4 years ago

    Hi Anonymous 
    Here is a sample file with the solution https://www.dropbox.com/t/wsVgfD6l6EA1AjId

    Time Expended = 
SUMX (
    VALUES ( Data[ID] ), 
    CALCULATE (
        VAR StartFinish1 = VALUES ( Data[Start / Finish] )
        VAR StartFinish2 = { "Start", "Finish" }
        VAR TotalTime = SUM ( Data[Time Delta] )
        VAR CrewSize = SELECTEDVALUE ( Data[Crew Size] )
        RETURN 
            IF ( 
                COUNTROWS ( INTERSECT ( StartFinish1, StartFinish2 ) ) = 2,
                CrewSize * TotalTime
            )
    )
)
tamerj1's avatar
tamerj1
Community Champion
4 years ago

Hi Anonymous 
Here is a sample file with the solution https://www.dropbox.com/t/wsVgfD6l6EA1AjId

Time Expended = 
SUMX (
    VALUES ( Data[ID] ), 
    CALCULATE (
        VAR StartFinish1 = VALUES ( Data[Start / Finish] )
        VAR StartFinish2 = { "Start", "Finish" }
        VAR TotalTime = SUM ( Data[Time Delta] )
        VAR CrewSize = SELECTEDVALUE ( Data[Crew Size] )
        RETURN 
            IF ( 
                COUNTROWS ( INTERSECT ( StartFinish1, StartFinish2 ) ) = 2,
                CrewSize * TotalTime
            )
    )
)