SQLBI Newsletter #172

NEW ARTICLE

Using calculation groups to selectively replace measures in DAX expressions

This article describes how to use calculation groups to dynamically replace only a partial expression in a complex DAX calculation.
Read more

#172 · Sep 2020

LEARNING

Course calendar

video courses

	DAX Patterns collection
	Intro to Data Modeling
	Data Modeling for Power BI
	Power BI Dashboard Design
	Introducing DAX
	Mastering DAX 2
	Optimizing DAX
	SSAS Tabular
	Power Pivot

Classroom courses

Check out the latest updates on our training page.

SQLBI YOUTUBE CHANNEL

Latest news

	• Analyze in Excel for Power BI Desktop 1.1.2 The latest version of Analyze in Excel for Power BI Desktop no longer creates an ODC file. This reduces the friction required to open a PivotTable over the data of your Power BI Desktop file. If you missed this new tool in August, this is your chance to learn and install it. Otherwise, check you have the latest version and send us your feedback if you run into any issue! Aug 26, 2020 · SQLBI
	• The hard truth in numbers Marco Russo wrote a blog post about data-driven decisions. It is hard to accept numbers that we do not like, but this seems to also happen to data professionals. Marco's recent survey about features in External Tools or in Power BI is an example of that. Aug 22, 2020 · Marco Russo
	• Power BI data protection updates Recently, Microsoft introduced a feature to declare the sensitivity of data in Power BI datasets. This information is now reflected in Power BI reports and in Excel PivotTables connected to Power BI datasets. Aug 18, 2020 · Microsoft
	• On-premises data gateway August 2020 update is now available It is always a good idea to keep your on-premises data gateway up to date! Aug 21, 2020 · Microsoft
	• DAX Studio and Tabular Editor – better together Darren describes in several blog posts how to improve DAX Studio by taking advantage of Tabular Editor features. You can generate a DAX query that computes all the DAX measures in a model by using a DMV query in DAX Studio, or you can do the same thing with a script in Tabular Editor. The latter offers better flexibility and control. Aug 26, 2020 · Darren Gosbell
	• Displaying routes on a map in Power BI Chris Webb describes how to create routes on a map in Power BI through the Icon Map custom visual. In doing so, he also uses techniques shown in a previous post, Power Query geography and geometry functions in Power BI and Excel. If you are displaying data on maps, these posts are a must-read. Aug 23, 2020 · Chris Webb
	• How to block the creation of a classic workspace in powerbi.com when a new MS Team is created There is a new tenant setting for Power BI to block classic workspace creation. This way, creating a new team in Microsoft Teams does not create an empty unused workspace in Power BI. A feature to disable a feature, great! Aug 18, 2020 · Nick Edwards
	• Tabular Editor 2.12.1 The latest version of Tabular Editor (2.12.1) offers improvements in scripting, better support for command-line execution, updates to latest libraries, and many bug fixes. Now that Tabular Editor is available as an External Tool in Power BI, you have no excuses for ignoring it! Aug 28, 2020 · Daniel Otykier
	• What Power BI fonts may help report viewers with dyslexia? Being strategic about the fonts you choose can make a small difference for many people, and a huge difference for people with dyslexia. Being aware of that is key to create more accessible reports! Aug 25, 2020 · David Eldersveld
	• Fun with Power BI and color math Talking about accessibility means describing how to make a report easier to understand for everyone. Choosing the right color contrast ratio is one of the things we can do to make a report clearer, and Meagan Longoria shows how a Power BI report can help you make the right choice for your own report! Aug 20, 2020 · Meagan Longoria

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.