NEW ARTICLE
SUMMARIZE is a DAX function, commonly used in measures that manipulate tables. This new article describes the internals of SUMMARIZE, and replaces a previous description that was partially outdated.
Read more

 
DAX PATTERNS
The ability to rank things is a very common requirement. Finding the best customers, computing the ranking position of products, or detecting the countries with the best sales volumes are among the questions most frequently asked by management. This pattern describes both static and dynamic ranking techniques.
Read more

 

SQLBI YOUTUBE CHANNEL
Latest videos
Development Tools for Power BI and Analysis Services models
72:56#liverecordedDaniel Otykier, Darren Gosbell
Auto-exist on clusters or numbers
41:20#unpluggedAlberto Ferrari
Optimizing the distribution of distance between transactions
45:34#unpluggedMarco Russo
Date and time parts
02:51#daxguideAlberto Ferrari
DATEDIFF, YEARFRAC
04:35#daxguideAlberto Ferrari
EDATE, EOMONTH
01:51#daxguideAlberto Ferrari

 


BI-WEEKLY NEWS DIGEST
Latest news
• Tabular Editor 3.0 is Generally Available!
Tabular Editor 3 has been released. The pricing has been disclosed. A 30-day evaluation is available to everyone. It is the best and most productive tool to write DAX code - and to create Tabular models. We had awaited this release for months, and now we finally have a professional development environment.
Jun 1, 2021 · Daniel Otykier
• Advanced incremental refresh with the XMLA endpoint
The quality of the Microsoft documentation is constantly improving and this article is proof of that. It describes the internal partitioning made by an incremental refresh in Power BI and how you can control it through the XMLA endpoint. Kudos!
May 14, 2021 · Microsoft
• Power BI Report Server May 2021 update
Microsoft released a new version of Power BI Report Server. Among the many updates, the performance improvements made to DAX (already available in the cloud service) are a good reason to update soon if you work with Power BI on-premises.
May 27, 2021 · Microsoft
• Ten Reasons Why I’m Excited About The New Power BI/Excel Integration Features
Excel is still (and will continue to be) the #1 tool to manage data. Thus, better integration with Power BI is expected and it is finally moving forward. Chris Webb shares his thoughts about using Excel (also) as a Power BI client!
May 23, 2021 · Chris Webb