Leveraging the WINDOW Function

The DAX function WINDOW is a relatively recent addition to the DAX language along with similar and related functions—INDEX, OFFSET, ORDERBY, and PARTITIONBY. These functions were released as part of an effort to bring visual-level calculations to Power BI.

In this recipe, the WINDOW function is used to compute a rolling 3-month average as well as a running total.

Getting ready

To prepare for this recipe, follow these steps:

1. Download Leveraging the WINDOW Function Start.pbix from the following GitHub repository: https://github.com/PacktPublishing/Power-BI-Cookbook-Third-Edition.
2. Open Leveraging the WINDOW Function Start.pbix in Power BI Desktop.
3. Edit the AdventureWorks query, and change the Source line to point to your SQL server with the AdventureWorksDW2022 database installed.
4. Click Close & Apply from the ribbon of the Home tab.
5. Save your work.

How to leverage the WINDOW function

...