Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
Yamin101
Frequent Visitor

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

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.

 

Lags.png

Lag Counts BI File  & Data in Excel  

1 ACCEPTED SOLUTION
saud968
Super User
Super User

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. 

View solution in original post

4 REPLIES 4
saud968
Super User
Super User

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. 

Hi Saud

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

Regards

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

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."

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.