I have two columns that are table calculations (If statements) based on returned measures.
The number of rows between non-null values in these two columns will vary.
What I need to do is measure the difference in seconds between the downtime_start column and downtime_stop column by iterating through rows until the column value is not null. It should always be the case that a downtime_start occurs before a downtime_stop. Any help would be greatly appreciated.