Removing a variable number of first rows in Power Query

preview_player
Показать описание
This video demonstrates two approaches to remove a variable number of first rows in Power Query (one with GroupKind.Local and the other with List.PositionOf).
Рекомендации по теме
Комментарии
Автор

Hi Pat,
Table.Skip function when used with a condition stops to skip rows when the condition becomes false.
So I can write Table.Skip ( TableName, each _[Value] = 0 )

I have been enjoying your videos a lot. Please keep them coming!

GoodlyChandeep