Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
Hello, @ValeriaBreve
Table.Skip(your_table, List.PositionOf(your_table[Column1], "ECC", Occurrence.First))
Hello, @ValeriaBreve
Table.Skip(your_table, List.PositionOf(your_table[Column1], "ECC", Occurrence.First))
works like a charm! Thanks 🙂
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.