SQLBI Newsletter #247

NEW ARTICLE

When a slicer contains many items, developers can filter the most relevant items using another slicer. The scenario is easily solved with a many-to-many relationship if the source is a regular table. Still, it requires some DAX coding if the slicer contains calculation items.
Read more

CLASSROOM COURSES

DAX: Atlanta and Cologne!

We have two new Mastering DAX classes:

Other cities/dates only in 2024, hurry up!!
Courses schedule

#247 · Jul 2023

LEARNING

Course calendar

Mastering DAX

	Sep 19-21 - Amsterdam
	Sep 27-29 - Chicago
	Nov 6-8 - Atlanta
	Dec 5-7 - Cologne

Data Modeling

	Nov 7-9 - 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

PREVIEW

The inspiration behind DAX Optimizer

While you wait to access the new DAX Optimizer tool (if you are not in the waitlist, you can still apply to enter the beta), you can read how we started the DAX Optimizer journey!
Read more

BI-WEEKLY NEWS DIGEST

Latest news

	• Power BI July 2023 updates No big features this month, but important fixes like those for On-Object interaction. Is it now usable? We will give it a try. It's summertime in the Northern hemisphere, a consolidation version is good news. Jul 11, 2023 · Microsoft
	• Evaluation order of DAX expressions in calculation groups What happens when the calculation item expression references the format string expression? If you know the answer, you have probably already read the complete analysis of how it works. Better not to be in that situation, but just in case... Jul 6, 2023 · Bernat Agulló Roselló
	• Performance testing Power BI Direct Lake mode datasets in Fabric At SQLBI we decided to wait before covering Fabric, as there are too many missing parts to control the semantic model. However, it is never too soon to take a look at who runs the first experiments, and testing the Direct Lake mode for a dataset is interesting. Jul 9, 2023 · Chris Webb
	• The tale of Tabular Editor Read the full story of Tabular Editor, the mandatory free and open-source tool whose development started in 2016. Jul 10, 2023 · Daniel Otykier
	• Using Tabular Editor in Microsoft Fabric If you think that Fabric will bring you a web browser-only experience, read this article. Productivity and advanced features are still (and will continue to be) a realm for dedicated tools. Jul 13, 2023 · Kurt Buhler
	• SQLBIts 2023 videos available! SQLBits is the largest conference for Data Platform, and it is also the most loved one by speakers and attendees. Why? For example, because videos of all the sessions are free on YouTube! The videos of SQLBits 2023 held in March 2023 are now available. Jun 14, 2023 · SQLBits

SQLBI YOUTUBE CHANNEL