UPDATED ARTICLE
This updated article (now including a video) describes how blank values considered in a DAX conditional expression can affect its query plan and how to apply possible optimizations to improve performance in these cases.
Read more

DAX PATTERNS
The Transition matrix pattern analyzes changes in an attribute assigned to an entity at regular intervals. For example, customers might receive a rating evaluation every month. Measuring the changes in rating between two points in time might require the evaluation of how many customers moved from one rating to another within the considered interval. The transition matrix enables the end-user to make this kind of analysis by just manipulating filters in a report and without having to write any custom query.
Read more

 

SQLBI YOUTUBE CHANNEL
Latest videos
Limiting the number of calculation items selected
17:26#unpluggedAlberto Ferrari
New preview features in DAX Studio 2.16
12:50#unpluggedMarco Russo
DETAILROWS
02:07#daxguideAlberto Ferrari
SUMMARIZE
04:01#daxguideAlberto Ferrari
DISTINCT, VALUES
03:34#daxguideAlberto Ferrari
ADDCOLUMNS
04:14#daxguideAlberto Ferrari

 


BI-WEEKLY NEWS DIGEST
Latest news
• Power BI June 2021 Update
The big news in the June 2021 update of Power BI is the preview of the paginated report visual. There are many other improvements; dataflows are now included in deployment pipelines. All the details in the official announcement.
Jun 25, 2021 · Microsoft
• What’s new in the June update of Power BI Report Builder
You can now download Power BI Report Builder from the Microsoft Store. Automatic updates, no admin permissions required. You no longer have any excuse to delay practicing on paginated reports.
Jun 2, 2021 · Microsoft
• Scanner API enhancements in Power BI Admin REST APIs
You can write scripts and create programs that retrieve metadata from large Power BI tenants. You can retrieve measure names within a dataset schema without having to open a connection with the dataset itself. And it also works on non-Premium workspaces.
Jun 28, 2021 · Microsoft
• Choosing Azure Analysis Services or Power BI Premium for large datasets
Power BI Premium now processes large models with a segment size of 8 million rows, instead of the default 1 million rows. There are now very few differences between Azure Analysis Services and Power BI Premium. An updated recap in this short blog post.
Jun 29, 2021 · Marco Russo
• Increasing refresh parallelism – and performance – in Power BI Premium
The XMLA endpoint in Power BI Premium enables partition management, as well as the parallelization of the processing that you can customize by writing TMSL scripts. Nothing new really, if you know Analysis Services... But how many of you remember where to put the maxParallelism attribute? A very useful resource.
Jul 27, 2021 · Chris Webb
• DAX Studio 2.16.1
The latest release of DAX Studio comes with many improvements, including the preview of Debug Commas (see the unplugged video) and query builder enhancements. The article is about the 2.16 release, even though minor fixes were released shortly after.
Jun 28, 2021 · Darren Gosbell
• Migrating Power BI report-level measures to the model
If you have many measures in a Power BI report connected live to a shared dataset and you would like to migrate them to the Tabular model, you now have a script that solves the problem.
Jun 21, 2021 · Michael Kovalsky