NEW ARTICLE
This article describes how to use KEEPFILTERS in DAX iterator functions to preserve arbitrarily shaped filters in context transition.
Read more

 
DAX PATTERNS
The week-related calculations pattern describes how to compute calculations such as year-to-date, same period last year, and percentage growth using a week granularity. This pattern does not rely on DAX built-in time intelligence functions. All the measures refer to the fiscal calendar because the nature of a calendar based on weeks is not compatible with the definition of months in a regular Gregorian calendar.
Read more

 

SQLBI YOUTUBE CHANNEL
Latest videos
Common mistakes in big data models
65:23Guy in a Cube & SQLBI
Answering a question about TOPN cross filtering
34:52#unpluggedAlberto Ferrari
Increasing compression in Power BI and Analysis Services
22:57#unpluggedMarco Russo
DIVIDE Performance
10:42Alberto Ferrari
Thank you 25K subscribers!
1:45SQLBI

 


BI-WEEKLY NEWS DIGEST
Latest news
• Power BI April 2021 Feature Summary
With the latest release of Power BI Desktop you can connect a composite model to a perspective defined in a dataset or in an Analysis Services database. The DAX language also introduced parameters for CROSSFILTER to manipulate the filter in many-to-many cardinality relationships. Finally, there are improvements to the performance of IF and SWITCH in common use cases. The complete announcement also mentions improvements in other areas.
Apr 16, 2021 · Microsoft
• How to update or create a measure to Power BI Premium Per user without having to publish entire dataset
If you change a measure in a Power BI model and you want to deploy the changes without having to refresh the entire dataset, you can use the ALM Toolkit tool following the detailed instructions of this article.
Apr 14, 2021 · Gilbert Quevauvilliers
• Processing Manager for tabular models
Discover a new free tool to simplify the management of processing large tabular models: Processing Manager. It is compatible with Power BI Premium and Analysis Services. Yes, you can use SSMS but this tool is simpler to use and can be executed via command line.
Apr 12, 2021 · Michael Kovalsky
• New Analysis Services client libraries
If you use DAX Studio with Power BI Premium or Azure Analysis Services, you want to update the MSOLAP client libraries. The long wait time when you activate the Server Timings or Query Plan panes is now addressed in the latest version of the MSOLAP libraries.
Apr 6, 2021 · Microsoft
• Tabular Editor 2.16.0
This version comes with several fixes. It can ignore lineage tags, a feature that is creating issues in the preview of composite models in Power BI.
Apr 21, 2021 · Daniel Otykier