SQLBI Newsletter #199

NEW ARTICLE

Deep dive into measure filters in Power BI Desktop

When you use a measure as a filter in a Power BI visual, the DAX code generated might show a different behavior depending on whether the measure is part of the values shown in the visual or not. In this article, we perform a deep analysis of the queries generated by Power BI with an example.
Read more

#199 · Sep 2021

LEARNING

Course calendar

video courses

	Mastering Tabular
	Intro to Data Modeling
	Data Modeling for Power BI
	Power BI Dashboard Design
	DAX Tools
	Introducing DAX
	Mastering DAX
	Optimizing DAX
	Power Pivot

DAX PATTERNS

Semi-additive calculations

Calculations reporting values at the start or the end of a time period are quite the challenge for any BI developer, and DAX is no exception. These measures are not hard to compute; the complicated part is understanding the desired behavior precisely. These calculations do not work by aggregating values throughout the entire period, as you would typically do for sales amounts. Instead, the calculations should return the value at the beginning or the end of a selected time period. These calculations are also known as semi-additive calculations.
Read more

SQLBI YOUTUBE CHANNEL

Latest news

	• Automating aggregations for Power BI now in public preview Microsoft announced the public preview of the automatic aggregations for DirectQuery in Power BI Premium. While this feature will not fix bad data models and bad DAX code, it can be useful to attract users who cannot or do not want to import data in memory. By calling it cache, everybody is happy. Aug 30, 2021 · Microsoft
	• On-premises data gateway August 2021 update We don't like having to mention data gateway updates every month. But there is no automatic update yet. So... update your gateway! Aug 27, 2021 · Microsoft
	• Matching DAX queries to visuals in a published Power BI report Thanks to the integration between Azure Log Analytics and Power BI, you can retrieve the execution time of reports consumed by users and isolate the visual generating a slow query in production. Of course, you can perform the analysis using Power Query and Power BI! Sep 5, 2021 · Chris Webb
	• Reducing meta data queries sent by Power BI to Synapse Power Query might send too many queries to the data source when you are editing the transformation. This article describes how this could be bad with Synapse. It shows an optimization approach reducing the risk of hitting the maximum number of concurrent open connections. Sep 6, 2021 · Asanka Padmakumara
	• Switch statement vs. switch expression in M Did you know that you can get different data types as a result depending on the syntax used for "switch" in Power Query / M? Ben Gribaudo consistently publishes content about M, the language of Power Query. This is just one of the many gems you can find on his blog. Sep 7, 2021 · Ben Gribaudo

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.