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...