SQLBI Newsletter #235

NEW ARTICLE

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

SQLBI+ UPDATE

We published new content on SQLBI+ (more info on the blog post announcement):

#235 · Jan 2023

LEARNING

Course calendar

Mastering DAX

Data modeling

	Apr 18-20 - Amsterdam

video courses

	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.

BI-WEEKLY NEWS DIGEST

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

SQLBI YOUTUBE CHANNEL