New article: Understanding the optimization of SWITCH
The SWITCH function in DAX has been optimized over the years. It is helpful to know what makes the optimization work best.
Read more


The new and returning customers pattern helps in understanding how many customers within a given time period are new, returning, lost, or recovered.
There are several variations to this pattern, each with different performance and results depending on the requirements. Moreover, it is a very flexible pattern that allows the identification of new and returning customers, or the computation of these customers’ purchase volume – also known as sales amount.
Read more


New dates in Europe and North America
The schedule for the second half of the year is ready.
Munich and Amsterdam are the cities we picked for our courses in Europe.
Other than Las Vegas next week, Chicago is the place for North America.
We already announced the dates in Australia a few weeks ago.

The bad news is that we will not be adding more dates to the 2022 schedule because we are busy producing new content. If you want to experience a full immersion with your peers in the classroom, hurry and book your seat before it is too late!

In the meantime, you can access our video courses, which do not run the risk of selling out.


Latest videos


Latest news
• Report performance impact of concurrent connections in DirectQuery
The “Maximum connections per data source” property should be neither too small nor too large for a DirectQuery dataset in Power BI, or else the performance of the report may be impacted.
Jun 12, 2022 · Chris Webb
• Swapping Gantt chart hierarchies with field parameters
Many articles were written upon the release of the new Field Parameters feature in Power BI. This piece about dynamically changing the hierarchy in a Gantt chart built using a standard Matrix is brilliant!
Jun 2, 2022 · Sam Fischer
• Power BI Notebooks
The .NET Interactive Notebooks can be configured to test the Power BI Api running C# and PowerShell scripts in Visual Studio Code.
Jun 15, 2022 · Stephen Maguire
• SQL Server Reporting Services 2022
A new version of SQL Server is coming, and SQL Server Reporting Services is back. Do not expect new features: the world is moving to the cloud. But you can extend the support of existing solutions for another 10 years.
Jun 10, 2022 · Microsoft