SQLBI Newsletter #176

NEW ARTICLE

KPIs in Tabular models for Power BI and Excel

A Tabular model can define a measure as a Key Performance Indicator (KPI), thus providing a visual indicator for status and trend. This article describes in detail the KPI settings needed to get the best result using Power BI and Excel as clients.
Read more

NEW ARTICLE

Dynamic format strings with calculation groups

This article shows two techniques based on calculation groups: how to implement dynamic format strings in regular measures, and how to perform weight conversion on the fly.
Read more

#176 · Oct 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.

DAX PATTERNS

Dynamic segmentation

The Dynamic segmentation pattern is useful to perform the classification of entities based on measures. A typical example is to cluster customers based on their spending volume. The clustering is dynamic, so that the categorization considers the filters active in the report. Indeed, a customer might belong to different clusters on different dates.
Read more

SQLBI YOUTUBE CHANNEL

Latest news

	• Power BI October 2020 update Besides many incremental improvements, this monthly release contains important new features in Power Query: dynamic M query parameters and automatic table detection from Excel and JSON files. Don't just stop at the new ~~logo~~ icon! Oct 20, 2020 · Microsoft
	• On-premises data gateway October 2020 update Besides the monthly announcement of a new data gateway update, the important takeaway is the .NET Framework requirement starting in January 2021. Check now whether you might have support issues on your gateway server before it is too late! Oct 14, 2020 · Microsoft
	• Doing Power BI the right way: validating data model results Paul Turley covers an important part of data model development: validating the numbers. Sometimes, this can be the most expensive side of a project. This is especially true when it is not planned in advance and an inaccurate calculation reaches a report in production, thus leading to wrong decisions. Make this validation a part of the regular development cycle. · Paul Turley
	• DAX Studio 2.13 released Improvements all the way: query builder, export data, view metrics, connection reliability, and much more. You can read the full details in Darren's blog post, but in any case, you absolutely have to update DAX Studio to the latest version. No, not tomorrow, do it now! Oct 20, 2020 · Darren Gosbell
	• VertiPaq Analyzer 2.0 preview 5 This should be the last preview release of VertiPaq Analyzer 2.0. The Relationships page now shows many-to-many cardinality relationships and bidirectional filters with different graphics and the ability to quickly filter these elements in large data models. Oct 24, 2020 · SQLBI
	• Use Visual Studio Code to create Power BI External Tool Developers can create external tools for Power BI using Visual Studio Code. Phil Seamark explains how to create an application that shows up in the External Tools ribbon of Power BI Desktop. Oct 19, 2020 · Phil Seamark
	• Chris Finlan at Raw Data by P3 Chris Finlan (product manager for Paginated Reports) and Rob Collie (former PM for Power Pivot for Excel) talk about the evolution of Paginated Reports, the licensing of Premium per user, and the challenges of being a program manager for widely-adopted software. It is an entertaining one-hour podcast we hope you will enjoy. Oct 20, 2020 · Chris Finlan

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.