Curbal has its own social media server on Mastodon. Check it out here!
Welcome to our Knowledge Base

Tip: Start typing in the input box for immediate search results.

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

Let us know your thoughts...

Table of Contents