cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ValeriaBreve
Helper V
Helper V

Logic for removing top rows on a table

Hello,

I am trying to combine Excel files with data formatted in different ways.

In some of the files, columns start at row 4, in others at row 2, etc

 

Only the rows above the columns are not empty - there are annotations etc.

 

How can I skip the first N table rows until a criteria is met? For ex., in my case until the word "ECC" is found in the first column - that would be my first column header throughout all files.

 

Thanks!

Kind regards

Valeria

1 ACCEPTED SOLUTION
AlienSx
Solution Sage
Solution Sage

Hello, @ValeriaBreve 

Table.Skip(your_table, List.PositionOf(your_table[Column1], "ECC", Occurrence.First))

View solution in original post

2 REPLIES 2
AlienSx
Solution Sage
Solution Sage

Hello, @ValeriaBreve 

Table.Skip(your_table, List.PositionOf(your_table[Column1], "ECC", Occurrence.First))

works like a charm! Thanks 🙂

Helpful resources

Announcements
Exciting changes

Power BI Community Changes

Check out the changes to the Power BI Community announced at Build.

May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Kudo Data Story carousel

Data Stories Gallery

Visit our Data Stories Gallery and give kudos to your favorite Data Stories.

Top Solution Authors
Top Kudoed Authors