SQLBI Newsletter #277

NEW ARTICLE

Context transition in DAX explained visually

This article describes the DAX context transition using a conceptual model based on a visual representation, as we did with filter context and row context in previous articles.
Read more

SQLBI REPLAY

Introducing horizontal fusion in DAX

Horizontal fusion is an optimization technique available in DAX to reduce the number of storage engine queries. In this article, we introduce this optimization with a few examples.
Read more

#277 · Sep 2024

LEARNING

Course calendar

Mastering DAX - 3 DAYS

	Sep 18-20 - Calgary
	Oct 14-16 - London
	Oct 30-Nov 1 - New York City
	Nov 12-14 - Seattle
	Nov 19-21 - Amsterdam
	Dec 2-4 - Copenhagen

DATA MODELING - 3 DAYS

	Sep 23-25 - Vancouver
	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

COURSES IN THE US

Mastering DAX in Seattle and New York City

Summer is over! We are already working on the 2025 calendar, but you still have two options in the United States before the end of 2024!

Oct. 30-Nov. 1, 2024: New York City
Nov. 12-14, 2024: Seattle

Overall schedule

BI-WEEKLY NEWS DIGEST

Latest news

	• Myths, Magic, and Copilot for Power BI The first deep review on Copilot for Power BI, and likely the first serious and agnostic evaluation of AI technologies applied to data analytics / business intelligence in general. It's time for a reality check. Sep 5, 2024 · Kurt Buhler
	• Semantic modeling without third-party tools If the author of Tabular Editor can write an article describing how you can do anything without using Tabular Editor, it means that the productivity improvement is just too high to be worried about losing users. Sep 4, 2024 · Daniel Otykier
	• Tuning Power BI Copilot with row labels and key columns And if you want to improve Copilot, you have work to do! Yes, there is no such thing as a free lunch. Aug 25, 2024 · Chris Webb
	• TMDL support for the ALM Toolkit The support of TMDL in ALM Toolkit is a very welcome feature that makes everything more readable! Sep 4, 2024 · Microsoft
	• DAX Studio 3.2.1 Many bug fixes and small improvements in the latest update of DAX Studio. Are you on an older version? What are you waiting for? Sep 5, 2024 · Darren Gosbell

SQLBI YOUTUBE CHANNEL