This video is about finding a way to calculate with Power Query in Excel the longest set of consecutive days a person was absent from work in a certain period.

The solution involves using M code:

List.Sum,

List.Range,

List.Max.

 

Learn by practicing: download the files.

The solution was inspired by a video by Faraz Shaikh’s: “Easiest way to do the Running Total Inside Group Data”