SQLBI Newsletter #217

NEW ARTICLE

This article analyzes the dynamic parameters feature in Power BI, unveiling some of the internals of its implementation.
Read more

DAX PATTERNS

Dynamic segmentation

The Dynamic segmentation pattern is useful to perform the classification of entities based on measures. A typical example is to cluster customers based on their spending volume.

#217 · May 2022

LEARNING

Course calendar

Mastering DAX

	May 23-25 - Amster
	Jun 21-23 - Seattle
	Jun 28-30 - Las Vegas
	Sep 28-30 - Brisbane
	Oct 4-6 - Melbourne
	Oct 10-12 - Sydney

Data modeling

	May 23-25 - NYC

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 clustering is dynamic, so that the categorization considers the filters active in the report. Indeed, a customer might belong to different clusters on different dates.
Read more

CLASSROOM COURSES

Registrations open for Australia

Marco is finally coming back to Australia in September and October, for three Mastering DAX classroom courses!

Don't miss this opportunity, book your seat before the courses sell out!
Overall schedule

BI-WEEKLY NEWS DIGEST

Latest news

	• Power BI May 2022 Updates The "field parameters" feature is the biggest piece of news in the latest Power BI release. Our main article in this newsletter is also dedicated to the internals of fields parameters, a feature in preview. Don't be surprised if the sample report doesn't work: you must first enable the preview feature! May 16, 2022 · Microsoft
	• Dynamic sorting and switching columns/rows with Field Parameters The large number of articles published in just a few days demonstrate that fields parameters are a hot feature. This one explores how to change the sort order of a hierarchy. May 20, 2022 · Kane Snyder
	• Bringing DataOps to Power BI If DataOps is a new concept for you, take the time to watch this 40-minute video that introduces why and how to build a development pipeline for Power BI with the concept of DataOps and tools like Azure DevOps and PowerShell. May 17, 2022 · John Kerski
	• Building a reporting solution using Excel Power Query Power Query in Excel is now available in Excel for the Mac (including the Power Query Editor) and in Excel Online (only for refresh). May 15, 2022 · Chris Webb

SQLBI YOUTUBE CHANNEL