Welcome to our Knowledge Base
Tip: Start typing in the input box for immediate search results.
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]))
)
Was this helpful?
Reader Interactions