SQLBI Newsletter #216

NEW ARTICLE - DAX 101

Context transition is one of the most obscure topics for DAX newbies. In this article, we introduce context transition, its effects, and how to leverage it rather than be scared of it.
Read more

DAX PATTERNS

Parameter table

The parameter table pattern is used to create parameters in a report, so that users can interact with slicers and dynamically change the behavior of the report itself.

#216 · May 2022

LEARNING

Course calendar

Mastering DAX

	May 18-20 - Copen
	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

For example, a report can show the top N products by category, letting the users decide through a slicer if they want to see 3, 5, 10 or any other number of best products. The values available for a parameter must be stored in one or more disconnected tables, which do not have a relationship with any other tables of the same model.
Read more

CLASSROOM COURSES

Mastering DAX in Las Vegas

You needed a good reason to go to Las Vegas this year, didn’t you?
How about the Mastering DAX classroom course in Las Vegas presented by Marco Russo, June 28 to 30?

Jokes aside, the team is working hard on producing more content for you.
This means that the last classroom course on the schedule until October will be Las Vegas.
Training schedule

BI-WEEKLY NEWS DIGEST

Latest news

	• Analyze in Excel Workbooks saved to OneDrive for Business If getting the proper OLE DB Driver to run Analyze in Excel is an issue, you will soon be able to open Analyze in Excel straight into a web page. One more reason to control the drillthrough in the dataset. Apr 25, 2022 · Microsoft
	• Bringing DataOps to Power BI DataOps and Power BI: is that possible? The entire series is dedicated to this topic - not just the latest post! Embrace the change. Apr 28, 2022 · John Kerski
	• Microsoft Analysis Services Projects for Visual Studio 2022 The Microsoft Analysis Services Projects extension is finally available for Visual Studio 2022. No new features, but at least you can use the latest version of Visual Studio! May 4, 2022 · Microsoft

SQLBI YOUTUBE CHANNEL