New article: Introducing window functions in DAX
This article introduces the syntax and the basics of the new window functions in DAX.


We published new content on SQLBI+ (more info on the blog post announcement):
Whitepaper: Windows Functions in DAX

Learn how to use the new DAX window functions (INDEX, OFFSET, and WINDOW) to manipulate tables by sorting and partitioning data.

Introducing Time Intelligence DAX Functions

This 1-hour session shows how to use the standard DAX time intelligence functions with and without a Date table in your data model.

Understanding Time Intelligence with DAX

This 2-hour session provides the best practices to implement time intelligence calculations using built-in DAX functions and custom calculations for more complex and non-standard requirements.

More about SQLBI+


Latest news
• Public preview of Power BI dataset scale-out
If you rely on the scale-out feature of Azure Analysis Services, you can now use them in Power BI Service: the scale-out is now available there as well, and the feature gap is almost closed. Now it's just a different licensing system.
Jan 18, 2023 · Microsoft
• Export Power BI to Excel with connected tables
The important point is that you can export up to 500,000 rows to Excel. The technical detail is that there is a connected table to do that. Just like DAX Studio, now in the Power BI Service by Microsoft!
Jan 20, 2023 · Microsoft
• M language specification in review: 2022
If you like posts like What happened in DAX in 2022 and you use Power Query, this post about M is for you!
Jan 2, 2023 · Ben Gribaudo
• Building multi-language reports for Power BI in 2023
Creating multi-language reports for Power BI is still more expensive than we would like it to be, but at least there is now a complete guide covering data and metadata.
Jan 24, 2023 · Microsoft
• Power BI Report Server January 2023 update
This is a good month for those working with Power BI on-premises: the feature gap with the cloud version is reduced thanks to the new release, which also includes DAX window functions!
Jan 25, 2023 · Microsoft


Latest videos
Debugging DAX measures in Power BI
53:04#articleMarco Russo
Variations on like-for-like comparison – Unplugged #45
09:10#unpluggedAlberto Ferrari
The Whiteboard #12: Many-to-Many Relationships
12:17#thewhiteboardMarco Russo
Welcome to SQLBI+
06:54#announcementMarco Russo