SQLBI Newsletter #214

NEW ARTICLE - DAX 101

Understanding the difference between a row context and a filter context is the first and most important concept to learn to use DAX correctly. This article introduces the filter context.
Read more

DAX PATTERNS

Hierarchies

The Hierarchies pattern describes how to implement calculations based on hierarchies.
For example, a measure can show sales as a percentage over the parent of the current level of the hierarchy.

#214 · Apr 2022

LEARNING

Course calendar

Mastering DAX

	May 18-20 - Copenhagen
	May 23-25 - Amsterdam
	Jun 21-23 - Seattle
	Jun 28-30 - Las Vegas
	Oct 11-13 - Melbourne
	Oct 17-19 - Sydney

Data modeling

	May 23-25 - New York
	Oct 5-7 - Sydney

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
	Power Pivot

Any other calculation can use the same approach by just customizing the calculation associated to each level of the hierarchy.

Read more

BI-WEEKLY NEWS DIGEST

Latest news

	• Track changes in Power BI Part 5 of a series, this piece covers the use of PBI Tools. Don't miss part 4 which described how to include the Power BI reports (and not only the Tabular model) in your source control system. Apr 5, 2022 · Kurt Buhler
	• TOM compatibility levels This starts with the words, "The missing documentation". That says it all. The piece bridges the gap, with yet-inexistent documentation about features introduced by each compatibility level in the Tabular model. As of today, the latest level is 1569. The Microsoft documentation only describes 1500... Mar 28, 2022 · Mathias Thierbach
	• Tabular Editor 2.16.6 The new release of the free version of Tabular Editor includes important improvements and fixes, with better support of the latest features in the Tabular model. Apr 2, 2022 · Daniel Otykier

SQLBI YOUTUBE CHANNEL

Latest videos

Row Context in DAX