Number Grouped Rows in Power Query - Monkey Shorts Episode 046
Also known as "number rows by partition" this is a super useful recipe to have in your Power Query arsenal. The basic goal is to provide each item in a group with a row number, restarting the numbering at row 1 when we move to the next group. As you'll see in this week's episode of Monkey Shorts, with the right recipe it's very easy.