Forum Discussion
datediff problems
Good morning, I wish to return a time (duration) in seconds from a certain element. As soon as I get the label "Ordre fermeture vanne de garde" which is a closing order for a valve, i want to...
I figured it out,
thank you v-xicai for the referral by using variables.For those of you who might be interested, here's the final formula :
Durée fermeture(secondes) = Var _DebutDate = CALCULATE( MAX('GU_BasseMaulde_CDEVDG'[Date et heure]), FILTER( ALLEXCEPT('GU_BasseMaulde_CDEVDG', GU_BasseMaulde_CDEVDG[EGF], GU_BasseMaulde_CDEVDG[Site]), GU_BasseMaulde_CDEVDG[Date et heure] < EARLIER('GU_BasseMaulde_CDEVDG'[Date et heure]) && 'GU_BasseMaulde_CDEVDG'[Description de l'évenement] = "Ordre fermeture vanne de garde" && GU_BasseMaulde_CDEVDG[Etat de l'évenement] = "Présente")) Var _FinDate = CALCULATE( MAX('GU_BasseMaulde_CDEVDG'[Date et heure]), FILTER( ALLEXCEPT('GU_BasseMaulde_CDEVDG', GU_BasseMaulde_CDEVDG[EGF], GU_BasseMaulde_CDEVDG[Site]), GU_BasseMaulde_CDEVDG[Date et heure] <= EARLIER('GU_BasseMaulde_CDEVDG'[Date et heure]) && 'GU_BasseMaulde_CDEVDG'[Description de l'évenement] = "Vanne de garde fermée" && GU_BasseMaulde_CDEVDG[Etat de l'évenement] = "Présente")) RETURN IF('GU_BasseMaulde_CDEVDG'[Description de l'évenement] = "Vanne de garde fermée" && 'GU_BasseMaulde_CDEVDG'[Etat de l'évenement] = "Présente", DATEDIFF(_DebutDate , _FinDate, SECOND), 0)
Am i correct in thinking that for "G01" you're looking for the difference in time for these two rows:
Which should be something along the line of 2 hours and 34 min ?
/J
No your not,
like i put on the 2nd picture, i need to get the time between the "start point" to the "finish point"