New article: Fields parameters in Power BI
NEW ARTICLE
This article analyzes the dynamic parameters feature in Power BI, unveiling some of the internals of its implementation.
Read more

 

DAX PATTERNS
The Dynamic segmentation pattern is useful to perform the classification of entities based on measures. A typical example is to cluster customers based on their spending volume.
The clustering is dynamic, so that the categorization considers the filters active in the report. Indeed, a customer might belong to different clusters on different dates.
Read more

 

CLASSROOM COURSES
Registrations open for Australia
Marco is finally coming back to Australia in September and October, for three Mastering DAX classroom courses!
Don't miss this opportunity, book your seat before the courses sell out!
Overall schedule
Mastering DAX Australia 2022

 

BI-WEEKLY NEWS DIGEST
Latest news
• Power BI May 2022 Updates
The "field parameters" feature is the biggest piece of news in the latest Power BI release. Our main article in this newsletter is also dedicated to the internals of fields parameters, a feature in preview. Don't be surprised if the sample report doesn't work: you must first enable the preview feature!
May 16, 2022 · Microsoft
• Dynamic sorting and switching columns/rows with Field Parameters
The large number of articles published in just a few days demonstrate that fields parameters are a hot feature. This one explores how to change the sort order of a hierarchy.
May 20, 2022 · Kane Snyder
• Bringing DataOps to Power BI
If DataOps is a new concept for you, take the time to watch this 40-minute video that introduces why and how to build a development pipeline for Power BI with the concept of DataOps and tools like Azure DevOps and PowerShell.
May 17, 2022 · John Kerski
• Building a reporting solution using Excel Power Query
Power Query in Excel is now available in Excel for the Mac (including the Power Query Editor) and in Excel Online (only for refresh).
May 15, 2022 · Chris Webb

 


SQLBI YOUTUBE CHANNEL
Latest videos
Understanding context transition
18:25#articleAlberto Ferrari
DATEADD, SAMEPERIODLASTYEAR
06:55#daxguideAlberto Ferrari
DATESBETWEEN
03:44#daxguideAlberto Ferrari
DATESMTD, DATESQTD, DATESYTD, TOTALMTD, TOTALQTD, TOTALYTD
05:58#daxguideAlberto Ferrari
PERMUT
01:10#daxguideAlberto Ferrari