SQLBI Newsletter #189

NEW ARTICLE

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

#189 · Apr 2021

LEARNING

Course calendar

video courses

DAX PATTERNS

Week-related calculations

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 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

View Web Version · Change Email Preferences · Unsubscribe

You are receiving this email because you have registered to a mailing list from sqlbi.com. If you would like to avoid similar emails in the future, please change your email preferences by clicking the link above.