Calculating changeover times (production processes)

Hi Anonymous,

Is this what you need? Please check out. 

Measure =
VAR nextProductID =
    CALCULATE (
        MIN ( Table1[ProductielD] ),
        FILTER (
            ALL ( 'Table1' ),
            'Table1'[Aansturing] = MIN ( 'Table1'[Aansturing] )
                && 'Table1'[Lijn] = MIN ( Table1[Lijn] )
                && Table1[ProductielD] > MIN ( Table1[ProductielD] )
        )
    )
VAR endTime =
    MIN ( Table1[Eindtijd def] )
VAR nextStartTime =
    CALCULATE (
        MIN ( Table1[Begintijd def] ),
        FILTER ( ALL ( Table1 ), Table1[ProductielD] = nextProductID )
    )
RETURN
    DATEDIFF ( endTime, nextStartTime, MINUTE )

Best Regards,

Dale

My pleasure.

Try this formula, please. Anonymous.

Measure 2 =
SUMX (
    'Table1',
    IF (
        [Measure] >= 0
            && [Measure] <= 30
            && ISBLANK ( [Measure] ) = FALSE (),
        1,
        0
    )
)

Best Regards,

Dale