SQLBI Newsletter #226

NEW ARTICLE - DAX 101

RANKX is a simple function that ranks a value within a list of values. Its use is simple but can be a source of frustration for newbies. In this article, we introduce the RANKX function with a few examples.
Read more

DAX PATTERNS

Transition matrix

The transition matrix enables end-users to analyze changes in attributes over time (like monthly customer ratings) by just manipulating filters in a report and without having to write any custom query.
Read more

#226 · Sep 2022

LEARNING

Course calendar

Mastering DAX

	Sep 28-30 - Brisbane
	Oct 4-6 - Melbourne
	Oct 4-6 - Amsterdam
	Oct 10-12 - Sydney
	Nov 9-11 - Chicago
	Nov 28-30 - Amsterdam
	Mar 21-23 - Dallas

Data modeling

	Nov 9-11 - Chicago
	Dec 5-7 - 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

BI-WEEKLY NEWS DIGEST

Latest news

	• DAX Studio 3.0.4 DAX Studio 3 was released 4 weeks ago: like any big release it came with several small issues, that have now been fixed in version 3.0.4. This is a no-brainer update. If you had been waiting to upgrade from v2, you no longer have an excuse! Sep 26, 2022 · Darren Gosbell
	• Power BI September 2022 update Several improvements without big new features for Power BI in September: hierarchical axis by default, conditional formatting for data labels, translation support for composite models, and more. Sep 13, 2022 · Microsoft
	• Preview of Horizontal Fusion The September release also includes a preview of a new optimization that should benefit DirectQuery more than VertiPaq - though it was implemented on both engines and reduces the number of storage engine queries, consolidating multiple requests into a single query. While in preview, it must be enabled explicitly. Sep 19, 2022 · Microsoft
	• On-premises data gateway September 2022 Usual reminder about upgrading the data gateway that is now aligned with the September 2022 update. Sep 14, 2022 · Microsoft
	• No Built-In Power Query Connector: Am I Stuck? If you must connect to a data source that does not have a built-in connector in Power Query, you still have several options to load data in Power BI or Excel. This article is a good recap. Sep 15, 2022 · Ben Gribaudo
	• Manipulate Tabular models with Python by using PyTabular If you think that you must learn C# to manipulate a Tabular model using TOM, you should realize that you can use any .NET language, including Python.NET. Thanks to the PyTabular package, this is also more Python-friendly! Sep 15, 2022 · Curtis Stallings
	• Super Fast Data Loads to Prod Switching a large model from development to production in Power BI can be painful because of the full refresh required. Restoring a Power BI Backup can be a more convenient way to do so. Sep 20, 2022 · Mike Carlo

SQLBI YOUTUBE CHANNEL