SQLBI Newsletter #167

NEW ARTICLE

Distinguishing HASONEVALUE from ISINSCOPE

This article describes the differences between HASONEVALUE and ISINSCOPE, which are two useful DAX functions to control the filters and the grouping that are active in a report.
Read more

NEW POST

7 reasons DAX is not easy

A long and entertaining blog post by Alberto Ferrari describing why DAX is simple, but not easy. The advice given here is based on the same secrets a seasoned coach would share with an eager young athlete.
Read more

#167 · Jun 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

	• Power BI Desktop June 2020 The new monthly release of Power BI Desktop introduces enhancements for mobile layout authoring, and important updates to the model view which is now available in live connect. You can see the relationships of the model you are consuming! Jun 10, 2020 · Microsoft
	• Split an existing Power BI file into a model and report When you want to promote a PBIX file to a shared dataset, you often want to move the report part into another file. Steve Campbell explains how to split a PBIX file into two different PBIX files: one with the data model, the other with the report. This is also useful if you move the model to Analysis Services and you want to keep the layout of the report. Jun 8, 2020 · Steve Campbell
	• DAX Studio: How measure formatting works Darren Gosbell describes in detail how DAX Studio formats measures included in query results. As a side note, there is a new version (2.11.1) with many fixes applied after the 2.11 release. Jun 5, 2020 · Darren Gosbell
	• Tabular Editor 2.11.0 Get ready for Power BI Desktop "External Tools" integration: The new version of Tabular Editor 2.11 is ready to keep the model synchronized between Power BI Desktop and Tabular Editor. Now we just wait for the next Power BI Desktop release! Jun 21, 2020 · Daniel Otykier
	• Optimizing the performance of Power Query merges in Power BI (Part 3 and 4) Chris Webb added another two articles to the series describing how to optimize merge operations in Power Query. This time the focus is on join operations. Jun 14, 2020 · Chris Webb
	• Icon Map custom visual James Dales created a web site to support the Icon Map custom visual for Power BI by using examples and use cases. If you want to plot data on a map, you should spend time on Icon Map. Jun 15, 2020 · James Dales
	• Improving the readability of the Matrix visual Mark Walter wrote a long and detailed blog post with practical suggestions to improve the visualization of a matrix in Power BI, based on practical use cases. The solution to a problem can be creative thinking instead of a new visual property. Jun 14, 2020 · Mark Walter
	• Migrate Analysis Services models to Power BI using Tabular Editor Marc Lelijveld published a step-by-step guide on how to migrate an existing Analysis Services model to Power BI. The same instructions are valid for on-premises and Azure versions of Analysis Services. Jun 16, 2020 · Marc Lelijveld
	• Power BI Report Server May 2020 - important update If you have Power BI Report Server, make sure that you upgrade to the latest version 15.0.1103.232. It fixes important bugs that were present in the previous version, 15.0.1103.227. Jun 15, 2020 · Microsoft
	• Buy and apply Power BI Premium license Seth Bauer introduces the differences between P sku (Power BI Premium licenses) and A sku (Azure capacity for Power BI Embedded). He explains how to apply the capacity to individual workspaces. Jun 16, 2020 · Seth Bauer

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.