Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Calculating changeover times (production processes)

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 ...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    8 years ago

    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 )

    Calculating_changeover_times_production_processes

     

    Best Regards,

    Dale

  • v-jiascu-msft's avatar
    v-jiascu-msft
    8 years ago

    My pleasure.

    Try this formula, please. Anonymous.

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

    Calculating_changeover_times_production_processes_2

     

    Best Regards,

    Dale

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Any one please?
  • v-jiascu-msft's avatar
    v-jiascu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    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 )

    Calculating_changeover_times_production_processes

     

    Best Regards,

    Dale

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Many many many thanks!

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      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's avatar
        v-jiascu-msft
        Icon for Microsoft Employee rankMicrosoft Employee
        8 years ago

        My pleasure.

        Try this formula, please. Anonymous.

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

        Calculating_changeover_times_production_processes_2

         

        Best Regards,

        Dale