NEW ARTICLE
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
DAX PATTERNS
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 videos
Fixing “Top N and others” report when filtering by date
44:27#unpluggedAlberto Ferrari
NONVISUAL
02:00#daxguideAlberto Ferrari
NATURALINNERJOIN, NATURALLEFTOUTERJOIN
04:27#daxguideAlberto Ferrari
ROLLUP
02:46#daxguideAlberto Ferrari
GENERATESERIES
02:16#daxguideAlberto Ferrari

 


BI-WEEKLY NEWS DIGEST
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