Select N preceding rows when column match is true
WITH cte AS (
SELECT *, 
       SUM(keyPerformanceIndicator) OVER (ORDER BY `date`, `time` 
                                          ROWS BETWEEN 10 PRECEDING 
                                                   AND CURRENT ROW) is_true_within_10
FROM datatable
)
SELECT * FROM cte WHERE is_true_within_10

If BigQuery does not support implicit convertions then use SUM(CASE keyPerformanceIndicator WHEN TRUE THEN 1 ELSE 0 END) and WHERE is_true_within_10 &gt; 0.