SQLBI Newsletter #215

NEW ARTICLE - DAX 101

CALCULATE is the most powerful and complex function in DAX. In this article, we provide an introduction to CALCULATE, its behavior, and how to use it.
Read more

DAX PATTERNS

Static segmentation

The Static segmentation pattern classifies numeric values into ranges.

#215 · 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

The price ranges are stored in a configuration table and the pattern requires the model to be entirely data-driven. In other words, when the configuration table is updated, the model is updated automatically without requiring any change to the DAX code.

Read more

BI-WEEKLY NEWS DIGEST

Latest news

	• Power BI April 2022 updates The Power BI updates this month are incremental improvements to existing features. No big announcements, but take a look at the Power BI Goals feature: it keeps getting updated so it does not seem like a "ship and forget" feature - there is something solid here. Apr 14, 2022 · Microsoft
	• On-premises data gateway April 2022 update We also have a new gateway to synchronize the engine with the April 2022 Power BI release. Until we get the automatic updates of the gateway, we must still manually update it. Apr 20, 2022 · Microsoft
	• Dictionary size in Tabular models reported by VertiPaq Analyzer If you see strange numbers in the column size when using the VertiPaq Analyzer feature integrated with DAX Studio, Tabular Editor, or Bravo, this article explains why you might observe a large dictionary size for small columns. Apr 16, 2022 · Marco Russo
	• Side effects of rounding differences in Power BI This blog post explores scenarios where you can see rounding differences in Power BI because of the data type chosen for imported columns. Apr 23, 2022 · Marco Russo
	• Filtering an Excel cube function report by a list of manually-entered values This article shows you how to leverage Excel functions to create a feature similar to Power BI custom visuals such as the Filter by List or Smart Filter visuals. Apr 17, 2022 · Chris Webb

SQLBI YOUTUBE CHANNEL

Latest videos

Filter Context in DAX