Exploring the Fifth Parameter of Table.Group Function in Power Query

Описание к видео Exploring the Fifth Parameter of Table.Group Function in Power Query

Table.Group Function is one of the most Important and Used Function in Power Query. Group By Option is directly available on the UI as well (Under both Home & Transform Tab).

Using it directly from UI takes three parameters and the fourth one - Group Kind is GroupKind.Global (1).
GroupKind.Local (0) is another option which is quite amazing and helpful in many instances.

There is also a Fifth parameter - Comparer Function. It allows us to specify a criteria for Grouping. I am still exploring it and presenting a case for it in the following video. The problem could have been solved in other ways too but would have required few extra steps. Using this fifth parameter, this could be solved using Just Table.Group Function.

Комментарии

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