SQLBI Newsletter #280

NEW ARTICLE

This article describes why week-based calendars (like 4-4-5) are important for specific industries and how to use them effectively in Power BI.
Read more

SQLBI REPLAY

Introducing dynamic format strings for DAX measures

Review the article about dynamic format strings, introduced in May 2023 and now generally available!
Read more

#280 · Oct 2024

LEARNING

Course calendar

Mastering DAX - 3 DAYS

	Oct 30-Nov 1 - New York City
	Nov 12-14 - Seattle
	Nov 19-21 - Amst
	Dec 2-4 - Copenhagen
	Feb 11-13 - Amsterdam
	Feb 18-20 - Phoenix
	Feb 24-26 - Dallas

DATA MODELING - 3 DAYS

	Dec 10-12 - Amsterdam

video courses

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

BI-WEEKLY NEWS DIGEST

Latest news

	• Power BI October 2024 Update An incremental update of visual calculations and other features. For DAX, an important piece of news is regarding auto-exists, named "value filter behavior". It is in preview and it should not affect existing models. We will write an article about this in the coming weeks. Oct 15, 2024 · Microsoft
	• Exploring Power Query buffering This article clarifies how Table.Buffer and List.Buffer work. Two important takeaways: the buffer operation is never recursive, and only does Table.Buffer have a delayed mode to materialize the buffer only if needed. More details in the article. Oct 3, 2024 · Ben Gribaudo
	• Automated testing for broken visuals How to implement automated testing for a report? We are still looking for a standard to test semantic models, but we should not forget the reports! Oct 8, 2024 · John Kerski
	• Why would you use Power BI Copilot? In case you were not paying attention to social media, the world seems divided between skeptics (who do not believe in AI at all) and enthusiasts (who expect AI to solve everything so we can just binge-watch our favorite shows). The reality is always way more complex with many shades of gray. This article implicitly contains more questions than answers, as should always be the case... Oct 13, 2024 · Chris Webb

SQLBI YOUTUBE CHANNEL

Latest videos

Identify Fabric and Power BI semantic model bottlenecks with DAX Optimizer