Window functions are a new addition to DAX launched in December 2022. They aim to simplify certain data operations which are very intuitive in Excel, but weren't so easy to replicate in DAX so far.

In this session we'll cover the 3 main window functions: INDEX, OFFSET and WINDOW to build meaningful insights. We'll see the power of these window functions by simplifying a previously lengthy DAX code and speeding up comparison-type analysis. We'll leverage the window functions to build a Pareto chart, a Cumulative chart and calculate delta comparing to last item.