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.
Dear DAX expert,
Previously I calculated the change over time between production orders with the following DAX:
Omsteltijden in seconden = VAR lastProductID = CALCULATE ( MIN ( RegistratieMaasland[ProductieID] ); FILTER ( ALL ( RegistratieMaasland ); RegistratieMaasland[Aansturing] = MIN ( RegistratieMaasland[Aansturing] ) && RegistratieMaasland[Lijn] = MIN ( RegistratieMaasland[Lijn] ) && RegistratieMaasland[ProductieID] = MIN ( RegistratieMaasland[ProductieID] ) - 1 ) ) VAR endTime = MIN ( RegistratieMaasland[Begintijd def] ) VAR startTime = CALCULATE ( MIN ( RegistratieMaasland[Eindtijd def] ); FILTER ( ALL ( RegistratieMaasland ); RegistratieMaasland[ProductieID] = lastProductID ) ) RETURN DATEDIFF ( StartTime; endTime; SECOND )
Valid outcome = SUMX ( RegistratieMaasland; IF( [Omsteltijden in seconden] >=0 && [Omsteltijden in seconden] <= 1800; [Omsteltijden in seconden]; BLANK()) )
Now I would like to change the valid outcome formula in a way that the outcomes are only valid when subnummer between productID has changed. This basically means that the changeover between an order is real (because of the change of subnummer).
Check herebelow for an example.
All help is greatly appreciated, if its not clear please ask,
Solved! Go to Solution.
Hi @Anonymous
You may try to use below measure:
Valid outcome =
VAR lastSubnumber =
LOOKUPVALUE (
RegistratieMaasland[Subnumber],
RegistratieMaasland[ProductieID], MAX ( RegistratieMaasland[ProductieID] ) - 1
)
RETURN
IF (
MAX ( RegistratieMaasland[Subnumber] ) = lastSubnumber,
BLANK (),
[Omsteltijden in seconden]
)
Regards,
Cherie
Hi @Anonymous
You may try to use below measure:
Valid outcome =
VAR lastSubnumber =
LOOKUPVALUE (
RegistratieMaasland[Subnumber],
RegistratieMaasland[ProductieID], MAX ( RegistratieMaasland[ProductieID] ) - 1
)
RETURN
IF (
MAX ( RegistratieMaasland[Subnumber] ) = lastSubnumber,
BLANK (),
[Omsteltijden in seconden]
)
Regards,
Cherie
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
88 | |
82 | |
65 | |
64 | |
58 |
User | Count |
---|---|
171 | |
112 | |
110 | |
72 | |
72 |