Large amount of CSV files into one table in Power BI

[benck]

I have a large amount of CSV files, and I would like to process them into one table with each row representing one CSV file.

For example, Trip001.csv:

Trip002.csv:

 I want to get [count the number of "FALSE" rows before the first apperance of "TRUE", with SPEED < 15.0] for each csv file. And the final result in Power BI should be like:

I know that it may be easier to process those CSV files using other language like Python before importing to Power BI. However, is it possible to do this in Power BI? Thanks.

[lbendlin]

This is very easy to do in Power Query, but it may be costly as you need to read each CSV file before you can compute the desired number of rows.  You can try some shortcuts like  Binary.Buffer/Table.Buffer and GroupKind.Local

Please provide your sample data in usable format, not a a screenshot.