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