SQLBI Newsletter #289

NEW ARTICLE

This article describes an Accounts Receivable Aging report in Power BI, and shows how to simplify a business problem using existing modeling patterns.
Read more

SQLBI REPLAY

Introducing window functions in DAX

This article introduces the syntax and the basic functionalities of DAX window functions: INDEX, OFFSET, and WINDOW.
Read more

#289 · Feb 2025

LEARNING

Course calendar

Mastering DAX - 3 DAYS

	Feb 24-26 - Dallas
	May 20-22 - Amsterdam
	May 28-30 - Chicago
	Jul 9-11 - Seattle

DATA MODELING - 3 DAYS

	Apr 14-16 - Amsterdam

video courses

	Introducing DAX
	Mastering DAX
	Optimizing DAX
	Intro to Data Modeling
	Data Modeling for Power BI
	Mastering Tabular
	DAX Tools Video Course
	DAX Patterns
	Power BI Dashboard Design

BI-WEEKLY NEWS DIGEST

Latest news

	• Power BI February 2025 update Copilot is slowly improving, with several updates, but no big news this month. Something is cooking for March/April? We expect something more significant for the Fabric Conference in Vegas (March 31). In the meantime, the news is that Power BI Desktop 32-bit is going out of support by the end of June 2025. Feb 21, 2025 · Microsoft
	• Displaying DAX query plans in a graphical way The DAX query plan provided by Microsoft is a long text file with an indentation that shows the hierarchical structure of the query plan. The Python code in this article generates a graphical representation of a DAX query plan. It is not clear as a SQL Server query plan, but it is a step forward from the text-only visualization. Feb 15, 2025 · Jake Duddy
	• Copilot improvements to write DAX queries in Power BI Copilot in Power BI now uses semantic model descriptions, synonyms, and sample values from columns to improve the generation of DAX queries. Far from being perfect, but there are real improvements here. Jan 26, 2025 · Microsoft

SQLBI YOUTUBE CHANNEL

Latest videos

Using pie charts is not the end of the world

18:01

#article

Kurt Buhler

Differences between ALL and ALLCROSSFILTERED

12:47

#article

Alberto Ferrari

Optimizing incremental inventory calculation in DAX

45:22

#article

Marco Russo

View Web Version · Status & Preferences · Unsubscribe

You are receiving this email because you have registered to a mailing list from sqlbi.com. If you would like to avoid similar emails in the future, please change your email preferences by clicking the link above.