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


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

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
• quiz - Learn DAX with some practice
Interesting initiative with several DAX questions that must be solved by using the online service, where you can generate a link to your solution and submit it in the article's comments.
May 28, 2023 · Kurt Buhler


Latest videos