Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

For loop Date Columns

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:

 

Need Help

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    Anonymous , 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])