For loop Date Columns

[robertoosthuize]

Hi All,

I have equipment downtime data that is used to calculate Mean Time Between Failure and Mean Time To Repair.  The fleet management system creates a new event frame every time a crew shift change occurs, thus splitting one long event into multiple shorter events.  This skews the MTBF and MTTR data.

I need to calculate the start time of the next event that are of the same time code whi8le ingoring events with the same ending and starting time.

I have ranked the events according to Start Time and Equip ID and then calculated Next Start, but without looping through the data.

Power BI and Sample Data link:

https://drive.google.com/drive/folders/1jcL0CtZEuz4RrHiITiXmY_2ECyzt3CNL?usp=sharing

Next Start Calculated Column

This is one long event split into smaller segments:

[amitchandak]

@robertoosthuize , Based on what I got.

Next start date will be , a new column

minx(filter(Table, [ID_eqip] = earlier([ID_eqip]) && [Start_date] > earlier([Start Date])),[Start Date])