NEW ARTICLE
This article provides you with the technical knowledge to choose between using a Date or an Integer to create the relationship between your fact table and the Date dimension.
Read more

 
DAX PATTERNS
The Related distinct count pattern is useful whenever you have one or more fact tables related to a dimension, and you need to perform the distinct count of column values in a dimension table only considering items related to transactions in the fact table. For demonstration purposes we use the distinct count of the product name in a model with two fact tables: Sales and Receipts.
Read more

 

SQLBI YOUTUBE CHANNEL
Latest videos
Adding working days to a date in DAX calculated column
30:08#unpluggedAlberto Ferrari
Explaining segment size in Power BI Premium
35:19#unpluggedMarco Russo
TREATAS
03:45#daxguideAlberto Ferrari
IGNORE
01:36#daxguideAlberto Ferrari
UNION
03:28#daxguideAlberto Ferrari
INTERSECT
03:10#daxguideAlberto Ferrari

 


BI-WEEKLY NEWS DIGEST
Latest news
• Power BI July 2021 Update
The July 2021 update of Power BI improves conditional filtering, upgrades several features as generally available, and introduces the preview of streaming dataflows. Read the blog post if you want to try the new Power BI Desktop infrastructure update using WebView2 instead of CefSharp. Yes, this topic is only for geeks!
Jul 21, 2021 · Microsoft
• Behind the scenes: Running the Power BI service
Microsoft describes how they run the Power BI service to serve 260,000 organizations in 52 Azure regions. The description of what can cause an incident and the incident process is enlightening. The numbers confirm a general perception: Power BI is a reliable service. Even though Murphy's law always applies.
Jul 21, 2021 · Microsoft
• Equals is not always equivalent: when query folding does not produce identical results
If you thought that only DAX can produce different results using DirectQuery or Import mode, think again! You can have similar issues with query folding in M because of the difference in semantics between comparison in M and in SQL!
Jul 23, 2021 · Ben Gribaudo
• Simple linear regression in DAX with calculation groups
You can create a calculation group to apply a linear regression to any measure in the model. Clearly, you could use the same approach to apply many other variations to the selected measure, displaying in the same chart multiple lines derived from the same measure.
Jul 29, 2021 · Sergio Murru
• Excel Cube functions, dynamic arrays and lambdas, part 1: Getting all the items from a set
Mixing the new Lambda helper functions in Excel with the good old Cube functions means new ways of creating dynamic reports connected to Power BI models.
Jul 28, 2021 · Chris Webb