Power Query - Index Column by Group & Return Last and First Record for a Group

Описание к видео Power Query - Index Column by Group & Return Last and First Record for a Group

In this video I show how you can create a index Column for a group (Partition by) and return the last and first records for a Grouped Table.
using a email dataset grouped by Email Subject. #data #dataanalytics #powerquery #powerbi #excel #partition #mquery #tutorial

Links
File
https://github.com/jbotes/powerbiTuto...

Video on Each and Underscore
   • Power Query - Understanding each and ...  

Mquery functions used
add index column
https://learn.microsoft.com/en-us/pow...
table last
https://learn.microsoft.com/en-us/pow...
table select rows
https://learn.microsoft.com/en-us/pow...
table addcolumns
https://learn.microsoft.com/en-us/pow...

Комментарии

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