Forum Discussion

sfernamer's avatar
sfernamer
Helper III
3 years ago
Solved

Calculate Hour Type Column Difference

Hi everyone,   I text you because I'm trying to calculate the difference between the hour values of the same column. The objective is to find the sum of time for every value of "Defensive Five" col...
DATEDIFF
LOOKUPVALUE
  • tamerj1's avatar
    tamerj1
    3 years ago

    Hi sfernamer 
    Here is a sample file containing my two previously proposed solutions. You are right about the 2nd solution, there was sime mistakes. Not sure if either what you're looking for.

tamerj1's avatar
tamerj1
Community Champion
3 years ago

Hi sfernamer 
Please create a new calculated column 

Expected Result =
VAR CurrentTime = 'Table'[Time]
VAR CurrentTable =
    CALCULATETABLE (
        'Table',
        ALLEXCEPT ( 'Table', 'Table'[GAme], 'Table'[Quarter] )
    )
VAR TableAfter =
    FILTER ( CurrentTable, 'Table'[Time] > CurrentTime )
VAR NextTime =
    COALESCE ( MINX ( TableAfter, 'Table'[Time] ), CurrentTime )
RETURN
    NextTime - CurrentTime