Print

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

DAX Fridays #218: Window functions in DAX explained with example
Window functions in Power BI and DAX

The code:

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

Reader Interactions

Leave a Reply

Your email address will not be published. Required fields are marked *

Table of Contents