Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
Solved! Go to 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
My pleasure.
Try this formula, please. @Anonymous.
Measure 2 = SUMX ( 'Table1', IF ( [Measure] >= 0 && [Measure] <= 30 && ISBLANK ( [Measure] ) = FALSE (), 1, 0 ) )
Best Regards,
Dale
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
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.
My pleasure.
Try this formula, please. @Anonymous.
Measure 2 = SUMX ( 'Table1', IF ( [Measure] >= 0 && [Measure] <= 30 && ISBLANK ( [Measure] ) = FALSE (), 1, 0 ) )
Best Regards,
Dale
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
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
Many many many thanks!
User | Count |
---|---|
88 | |
72 | |
69 | |
65 | |
57 |
User | Count |
---|---|
95 | |
93 | |
91 | |
75 | |
69 |