work with offset rows

[Anonymous]

Hello,

i have a machina which save time data in a base at each time we change the product (column 3). But sometimes the machina have a bug and write a rows without reason.

So i have this data, but i want this :

You will see that the End Time is the same than the Start Time at the next row. But i want merge the data on one row if the product number is the same to have the good duration for each product.

Thanks a lot...

horodatage debut	horodatage fin	produit
01/01/2022 06:00:00	01/01/2022 08:00:00	FL1004
01/01/2022 08:00:00	01/01/2022 12:00:00	FL1004
01/01/2022 12:00:00	02/01/2022 08:00:00	FL1004
02/01/2022 08:00:00	02/01/2022 14:00:00	FV0937
02/01/2022 14:00:00	03/01/2022 09:00:00	FN1199
03/01/2022 09:00:00	03/01/2022 11:00:00	FN1199
03/01/2022 11:00:00	03/01/2022 14:00:00	FV0937

[Greg_Deckler]

@Anonymous Create a Group By step in Power Query Editor? Alternatively in DAX you can work with offset rows using something like MTBF. See my article on Mean Time Between Failure (MTBF) which uses EARLIER: http://community.powerbi.com/t5/Community-Blog/Mean-Time-Between-Failure-MTBF-and-Power-BI/ba-p/339586.
The basic pattern is:
Column = 
  VAR __Current = [Value]
  VAR __PreviousDate = MAXX(FILTER('Table','Table'[Date] < EARLIER('Table'[Date])),[Date])

  VAR __Previous = MAXX(FILTER('Table',[Date]=__PreviousDate),[Value])
RETURN
  __Current - __Previous