How to Count Numbers (Lag) after FS, SS, SF & FF from Primavera P6 Data?

[Yamin101]

Hi There

Got a parser from Primavera P6.

I can calculate the number of FS, SS, SF & FF logics as you can see in the attached file. I need to Count the numbers right after FS, SS, SF & FF logics.
Power BI files & Excel data are also attached. The overall lags are 4574 & later I need to calculate Lags that are greater than 10 the answer for this is 93.

Lag Counts BI File  & Data in Excel  

[saud968 · Accepted solution]

I could not download your PBIX due to restrictions on my laptop. For now, I can recommend splitting or extracting the data in Power Query and then you can do a count of the numbers of that column accordingly. 

[Yamin101]

Hi Saud

I have uploaded it again, please check. 
I have tried splitting the data but was unable to fix it.

Regards

[saud968]

Allow me sometime, as I am working on my own project will take sometime to complete it.

[Yamin101]

Just I need to look at the advanced feature and all more than 25 columns.

"I can recommend splitting or extracting the data in Power Query and then you can do a count of the numbers of that column accordingly."