SQLBI Newsletter #170

NEW ARTICLE

The LOOKUPVALUE function retrieves values from a table in a simple way, but it involves a hidden level of complexity. Four weeks ago we published an introduction to LOOKUPVALUE. This new article provides full coverage of the internals of LOOKUPVALUE, along with several performance considerations.
Read more

NEW POST

Arbitrary combination of measures and calculation items

The consumption experience following the introduction of calculation groups needs to be improved in Power BI. This blog post explains the need for a feature to enable the selection of arbitrary combinations of measures and other table/column items in visuals.
Read more

#170 · Aug 2020

LEARNING

Course calendar

video courses

	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

We are rescheduling courses as required by the ongoing situation, and in the meantime we have made sure to keep supporting our students on their learning path.
Check out the latest updates on our training page.

SQLBI YOUTUBE CHANNEL

Latest news

	• External tools to document your Power BI model Everybody wants documentation, nobody wants to write it. So why not use Power BI as an external tool to document a Power BI model, thanks to a Power Shell script? Marc shared this with all of us! Jul 28, 2020 · Marc Lelijveld
	• Python as an External Tool for Power BI Desktop The External Tools ribbon could become the busiest one in Power BI if you install all the tools coming out. This example shows how to integrate Python so that in a separate window, you can access data in Power BI and export or visualize them in different ways. The article is split into different parts, the link points to the first part. Jul 20, 2020 · David Eldersveld
	• DAX Studio 2.12.1 We finally have DAX Studio with a code-signing certificate that removes the annoying security warning at download and installation time. Plus, additional new features and many bug fixes. You can finally forward this link to your network administrators without scaring them! Aug 3, 2020 · Darren Gosbell
	• Tabular Editor 2.11.7 Several fixes and small new features in this update of Tabular Editor, which is now largely adopted thanks to External Tools in Power BI. The frequency of updates of this tool - and the speed in addressing bugs - is amazing. Jul 30, 2020 · Daniel Otykier
	• How to force your visual to always be on top? There are many ways to control the z-order of visuals in Power BI and to "manage" the overlap between visuals. This interesting blog post explores the pros and cons of three possible solutions. Jun 29, 2020 · Maksym Myronenko
	• Gradient legends in Power BI One of the many new features introduced by Power BI Desktop July 2020 is the gradient legend that can be applied to a bar chart. This post describes in detail how to use this feature and the results you can obtain. Jul 25, 2020 · Laura Graham-Brown
	• Adding tooltips to column headers in the Power Query editor in Power BI and Excel Did you know you can make tooltips appear when you hover over column headers in a table in the Power Query editor in either Power BI Desktop or Excel? It's all done with M metadata... Jul 19, 2020 · Chris Webb
	• Doing Power BI the right way: Future-proofing Power BI solutions In this blog post that may be the first of a very long series, Paul shares his thoughts about planning a Power BI solution correctly. While Power BI can initially be seen as a simple tool to create quick reports, it can also be a pillar of enterprise-grade solutions, which require some planning if you don't want to rebuild everything from scratch in the middle of your project. Jul 29, 2020 · Paul Turley

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.