SQLBI Newsletter #240

NEW ARTICLE

Optimizing SWITCH on slicer selection with Group By Columns

This article describes how to use the Group By Columns property to store the slicer selection by using the same column used in a SWITCH function to optimize the query performance.
Read more

SQLBI+ UPDATE

New Content on SQLBI+

We released another update on SQLBI+ (more info on the blog post announcement):

#240 · Apr 2023

LEARNING

Course calendar

Mastering DAX

	Apr 17-19 - Copenhagen
	May 17-19 - Seattle
	May 22-24 - Chicago
	Jun 14-16 - Perth
	Jun 20-22 - Sydney
	Jun 26-28 - Brisbane
	Jun 27-29 - Amsterdam

Data modeling

	Apr 18-20 - 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
	Power Pivot

Different types of many-to-many relationships

This 1-hour session explains the different meanings of "many-to-many" relationships: the cardinality type of a Power BI relationship does not correspond to the canonical meaning of many-to-many relationships between business entities in a data model.

More about SQLBI+

CLASSROOM COURSES

Mastering DAX in Australia

Marco will be in Australia in June 2023 for three Mastering DAX classroom courses!

Hurry and book your seat before the courses sell out!
Overall schedule

BI-WEEKLY NEWS DIGEST

Latest news

	• Navigating the Data Ecosystem: a revolutionary analytics architecture You should never trust an article published on April 1st, because it is likely to be there for April Fools' Day. And this is written by none other than ChatGPT-4! Apr 1, 2023 · ChatGPT-4
	• Behind the scenes of an April Fools’ Day Reading how we used ChatGPT-4 to write the April Fools' Day article is even more interesting. The first prompt is not always the right one. Apr 2, 2023 · Marco Russo
	• How to manage Reporting Objects in a Power BI dataset Should a semantic model include report-specific objects? In Power BI there are no choices, you must mix them with the true semantic model objects. But we can try to keep them separate as much as possible following a few best practices. Apr 4, 2023 · Kurt Buhler
	• Identifying CPU and memory-intensive Power Query queries during refresh in the Power BI service The Profiler provides information about CPU and memory consumed by Power Query transformations during a process refresh. These details are hidden in the textual description of the event. We are waiting for a better user experience in DAX Studio to read these events. Apr 2, 2023 · Chris Webb

SQLBI YOUTUBE CHANNEL