SQLBI Newsletter #281

NEW ARTICLE

Building bullet charts in Power BI reports

This article is about how to read and use bullet charts when comparing actuals to a target in Power BI, and the different options you have available to make these charts in Power BI reports.
Read more

SQLBI REPLAY

Understanding the optimization of SWITCH

The SWITCH function in DAX has been optimized over the years, and it is helpful to know what makes the optimization work best.
Read more

#281 · Nov 2024

LEARNING

Course calendar

Mastering DAX - 3 DAYS

	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

UPCOMING CLASSROOM COURSES

Mastering DAX in Q1 of 2025

As far as 2024 is concerned we only have a few seats left in Copenhagen. Registrations are open for Mastering DAX in 2025 on the following dates:

Dec. 2-4, 2024: Copenhagen, DK
Feb. 11-13, 2025: Amsterdam, NL
Feb. 18-20, 2025: Phoenix, AZ (US)
Feb. 24-26, 2025: Dallas, TX (US)

This is it for Q1 of 2025, so hurry and book your seat!

Overall schedule

BI-WEEKLY NEWS DIGEST

Latest news

	• DAX Optimizer in Tabular Editor 3 The new 3.18 version of Tabular Editor includes free access to DAX Optimizer for Enterprise Edition customers. The integration between the two tools is now generally available to everyone. Moreover, do not miss the new Code Actions feature to quickly refactor your DAX formulas. Oct 31, 2024 · Morten Lønskov
	• Understanding the impact of value filter behavior The auto-exists feature in DAX is going to change. SUMMARIZECOLUMNS is the impacted function, but this article is important even if you do not write DAX code at all! The setting in the model is going to change how a Power BI report works in certain conditions. Oct 22, 2024 · Jeffrey Wang
	• Finding the columns touched by a DAX query The new INFO.CALCDEPENDENCY function makes it easier to extract the dependency information formerly available only through specific data management views (DMVs). Oct 20, 2024 · Chris Webb
	• Understand star schema and the importance for Power BI Microsoft is investing in improving their documentation. They have been adding important content about data modeling that is so important to create effective solutions. Kudos to them for covering star schemas in detail! Oct 29, 2024 · Microsoft
	• A pricing estimator for Power BI & Microsoft Fabric When there are too many options to quote a service - in there lies the opportunity to create a cost estimator! Only for the US and the UK at this time. Oct 31, 2024 · Daniel Whittaker

SQLBI YOUTUBE CHANNEL