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!
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!
Great tip! That's a better way to do it.