SQLBI Newsletter #266

NEW ARTICLE

Using EXPAND and COLLAPSE in visual calculations

This article provides examples of visual calculations where the use of EXPAND and COLLAPSE is required to obtain the correct result.
Read more

NEW ARTICLE

Using scatterplots to find details in reports

This article describes how you can use a scatterplot visual for more effective Power BI reports.
Read more

#266 · Apr 2024

LEARNING

Course calendar

INTRO TO DAX - 1 DAY

	Apr 30 - Chicago
	May 27 - Amsterdam

Mastering DAX - 3 DAYS

	Apr 15-17 - New York City
	May 6-8 - Seattle
	May 14-16 - Hamburg
	May 22-24 - Copenhagen
	Jun 25-27 - Chicago
	Aug 6-8 - Melbourne
	Aug 12-14 - Sydney
	Aug 19-21 - Brisbane

ADVANCED DAX - 1 DAY

	May 1 - Chicago
	May 28 - Amsterdam

DAX OPTIMIZATION - 1 DAY

	May 2 - Chicago
	May 29 - Amsterdam
	Aug 9 - Melbourne
	Aug 15 - Sydney

Data Modeling - 3 DAYS

	Jul 2-4 - Amst

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

NEW BLOG POST

Direct Lake vs. Import mode in Power BI

What is the right choice between Direct Lake and Import mode in Power BI?

Too many people have an incorrect perception of Direct Lake, which should be addressed as soon as possible to avoid architectural mistakes and unnecessary additional implementation costs.

BI-WEEKLY NEWS DIGEST

Latest news

	• Power BI March 2024 udpate Many improvements and... Copilot to write DAX queries, described in another piece of news. The more important feature is the selection expression for calculation groups. It's only available through Tabular Editor for now. In future articles, we will explain what you can do with it. Mar 26, 2024 · Microsoft
	• Deep dive into DAX query view with Copilot Detailed explanation about using Copilot to write DAX queries. We do not want to evaluate this feature while it is in preview, it is better if you read this article to understand possible use cases and limitations. Apr 2, 2024 · Microsoft
	• Get data with Power Query available in Power BI Report Builder Paginated reports can use Power Query transformations. Many reports should be built in Power BI Report Builder instead of Power BI Desktop (or Service): by using Power Query, you can skip the semantic model. Sometimes that is just what you need! Mar 26, 2024 · Microsoft
	• DAX Optimizer generally available DAX Optimizer is generally available and the launch offer expires at the end of April. Shameless plug, we know, but we are so proud of this tool, please forgive us! Mar 26, 2024 · Tabular Tools

SQLBI YOUTUBE CHANNEL