SQLBI Newsletter #244

NEW ARTICLE

Implementing linear regression in Power BI

The LINESTX DAX function simplifies the calculation of linear regressions. This article explains the correct way to manage its results efficiently.
Read more

THE NEWS BEFORE THE NEWS

Microsoft Fabric

If you do not live offline, you have likely heard about Microsoft Fabric, the new end-to-end analytics solution that includes Power BI.

Several features of Microsoft Fabric (like Direct Lake) are interesting for Tabular models and DAX users: we will cover them in future articles and videos as soon as we have enough experience and insights to provide added value to the existing documentation. In the meantime, trying the product and familiarizing yourself with the Fabric architecture is a good idea, as it is the future direction of the Microsoft ecosystem for data analytics.
Microsoft Fabric

#244 · Jun 2023

LEARNING

Course calendar

Mastering DAX

	Jun 14-16 - Perth
	Jun 20-22 - Sydney
	Jun 26-28 - Brisbane
	Jun 27-29 - Amsterdam
	Sep 27-29 - Chicago
	Nov 6-8 - Atlanta

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

BI-WEEKLY NEWS DIGEST

Latest news

	• Power BI May 2023 Update This month, many features are now GA (Generally available) and there are several new features related to Microsoft Fabric in public preview. The new MATCHBY function in DAX is the object of a separate piece of news. May 25, 2023 · Microsoft
	• On-premises data gateway May 2023 release Fabric also affects the gateway: this update of the data gateway added support for Lakehouse connectivity over the gateway. Update to the latest version to be able to load your on-premises data into a Lakehouse. May 25, 2023 · Microsoft
	• Introducing MATCHBY for DAX window functions Deep explanation of a MATCHBY use case, describing the problems that it is designed to solve. We will cover it in a future update of the whitepaper on SQLBI+ (we expect more news to come). May 25, 2023 · Jeffrey Wang
	• Reducing the number of queries generated by Excel Cube functions Excel functions like CUBEVALUE and CUBEMEMBER can generate more queries than necessary when connected to a Tabular model. The article explains how to write the Excel formulas to reduce the number of queries generated. May 21, 2023 · Chris Webb
	• DAX.do quiz - Learn DAX with some practice Interesting initiative with several DAX questions that must be solved by using the online dax.do service, where you can generate a link to your solution and submit it in the article's comments. May 28, 2023 · Kurt Buhler

SQLBI YOUTUBE CHANNEL