Easy guide for understanding Window functions in DAX

Have you heard about the window functions that were released in Dec 2022? In this video I will explain how they work and future ones we will go through each new function in a separate video.

Watch the tutorial on YouTube

The code:

salaries by dept = 
CALCULATE(
    [Salaries],
    WINDOW(
        2, ABS,
        -1,ABS,
        SUMMARIZE(ALLSELECTED(salaries), salaries[depname], salaries[employeeID]), , 
        partitionby(salaries[depname]))
        )