Calculating changeover times (production processes)

[Anonymous]

Hi all,

I have a question regarding the calculation of change over times per supervisor per line.

I would like to gain insights in the change over times per supervisor and per line. 

The change over time is the difference between end time of a production order and the starting time of the next one on a production line.

It would be nice if someone can help me out on this.

[v-jiascu-msft · Accepted solution]

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

[Anonymous]

Any one please?

[v-jiascu-msft · Accepted solution]

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

[Anonymous]

@v-jiascu-msft

I have added an IF statement to filter on reliable (betrouwbaar) and unreliable (onbetrouwbaar), so I can filter between shifts (filtering out all unreliable values).  

Omsteltijden voorwaarden = 
IF( [Omsteltijden in minuten] > 30; "Onbetrouwbaar" ; IF( [Omsteltijden in minuten] <0 ; "Onbetrouwbaar" ; "Betrouwbaar"))

Now I was wondering  if you know some DAX code to calculate the reliable (betrouwbaar) values per lijn. In this way I can monitor the changeover times per day per supervisor, and discuss them with my supervisors.

[v-jiascu-msft · Accepted solution]

My pleasure.

Try this formula, please. @Anonymous.

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

Best Regards,

Dale

[Anonymous]

Hi Dale, thanks for previous solution. Working out quite well for me!

Would you know some DAX code to calculate the total changeover time per day/week (time period) ?

Best,

Luuk

[v-jiascu-msft]

Hi Luuk,

I would suggest you open a new thread in this forum. As far as I know, that can't be done by a single function. Please point out which DateTime column is used as a time period.

Best Regards,

Dale

[Anonymous]

Many many many thanks!