SQLBI Newsletter #187

NEW ARTICLE

Specifying multiple filter conditions in CALCULATE

This article introduces the new DAX syntax (March 2021) to support CALCULATE filter predicates that reference multiple columns from the same table.
Read more

NEW POST

On choosing names for new technologies

A name is important. The right name is important. In this post, Alberto reflects on the choice of names in the Microsoft BI stack.

#187 · Mar 2021

LEARNING

Course calendar

video courses

SQLBI YOUTUBE CHANNEL

Latest news

	• Support of external tools in Power BI Desktop is GA Microsoft announced the general availability (GA) of the "external tools" feature we have been using since July 2020. This is important news for those companies worried about features support. The article includes links to several community tools – not just the famous ones! Mar 19, 2021 · Microsoft
	• On-premises data gateway March 2021 update We are in 2021, and you still have to upgrade your data gateway manually. Thus, this reminder can be useful, right? If you use the data gateway, keep it synchronized with your Power BI Desktop version! Mar 16, 2021 · Microsoft
	• Power Query M Primer: Metadata If you think that the user interface in Power Query is powerful, you have to find a better adjective for M (the language used in Power Query). Did you know you can use M metadata to add functions and parameters documentation? We did not, but Ben Gribaudo explains that in a great article. Mar 17, 2021 · Ben Gribaudo
	• Optimizing HR Headcount DAX Measure with Power BI A common implementation of the Events in progress DAX pattern is the headcount. In companies with thousands of employees, performance might be an issue and the snapshot may not be enough. You also have to pay attention to the DAX measures. This post analyzes query performance in several scenarios. Mar 27, 2021 · Sergio Murru
	• DAX Studio 2.15 Released A large number of bug fixes, many small new features to increase your productivity: read and watch what's new with DAX Studio in Darren's blog post. If you are in a hurry, just install it! Mar 28, 2021 · Darren Gosbell
	• Tabular Editor 2.15.2 The latest update includes new features for advanced properties (synonyms, group by columns) and updated TOM libraries that fix connection issues with Power BI Premium per User. Mar 25, 2021 · Daniel Otykier
	• Improving the Performance of Importing Data from ADLSgen2 in Power BI by Partitioning Tables We have been using this trick at SQLBI for months, but we never had the time to write an article about it. Chris Webb took care of that in this blog post. FYI the same principle would apply for example if you read data from many files inside a folder named after a range of dates. Yes, there is still much to be written about this topic. Mar 19, 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.