Power Query Running Count with Grouping & Add Index - Excel Magic Trick 1589

Описание к видео Power Query Running Count with Grouping & Add Index - Excel Magic Trick 1589

Download Excel File: https://excelisfun.net/files/EMT1589....
Learn how to Create a Running Count for Product Names using the Grouping and Add Index Feature. Learn how to edit your M Code. See the Power Query functions: Table.AddColumn, Table.Group, Table.AddIndexColumn and Table.Combine. This trick is a method that can calculate more quickly than the method seen in Excel Magic Trick 1588. This trick comes from our YouTube Teammates Vida and Bill Szysz.

Комментарии

Информация по комментариям в разработке