SQLBI Newsletter #196

NEW ARTICLE

Choosing between Date or Integer to represent dates in Power BI and Tabular

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

#196 · Aug 2021

LEARNING

Course calendar

video courses

DAX PATTERNS

Related distinct count

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

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.