A very common scenario in Power Query is to remove top N rows. Often this has to be dynamic as the source data is provided in an inconsistent manner each period.
This trick of editing Remove Top rows to make it dynamic really should be a UI option.
= Table.Skip(PriorStep,each [Column1]<>"HeadingYourLookingFor")
Either add a Sub menu icon to Remove Top Rows, or add it as an optional feature in the Remove Top Rows dialogue
1 Comment
- Status added:New
