SQLBI Newsletter #227

NEW ARTICLE

Using cross-highlight with order and delivery dates in Power BI

This article describes how to enable the cross-highlight in Power BI charts using different dates for the same event, such as Order Date and Delivery Date.
Read more

DAX PATTERNS

Week-related calculations

The week-related calculations pattern describes how to compute calculations such as year-to-date, same period last year, and percentage growth using a week granularity.

#227 · Oct 2022

LEARNING

Course calendar

Mastering DAX

	Nov 9-11 - Chicago
	Nov 28-30 - Amsterdam
	Mar 21-23 - Dallas

Data modeling

	Nov 9-11 - Chicago
	Dec 5-7 - Amsterdam

video courses

	Mastering Tabular
	Intro to Data Modeling
	Data Modeling for Power BI
	Power BI Dashboard Design
	DAX Tools
	Introducing DAX
	Mastering DAX
	Optimizing DAX
	Power Pivot

This pattern does not rely on DAX built-in time intelligence functions. All the measures refer to the fiscal calendar because the nature of a calendar based on weeks is not compatible with the definition of months in a regular Gregorian calendar.
Read more

BI-WEEKLY NEWS DIGEST

Latest news

	• Power BI data visualization: ideas & wishlist Some would say that Power BI does not have the visualization quality of other tools. It takes days or weeks to compile a detailed analysis of what is missing to compete in the realm of data visualization. This piece provides clear examples and descriptions. Oct 4, 2022 · Kurt Buhler
	• Deployment History feature for Power BI deployment pipelines Power BI deployment pipelines now offer a log to track the history of deployments. It's possible to add notes. Correct, this feature is new. Oct 5, 2022 · Microsoft
	• DataOps principle: Analytics is Manufacturing Creating a set of tests for your Tabular models and DAX measures is an important part of the DataOps principles. While a specific tool does not yet exist, it is already possible to create a decent automated system. Oct 4, 2022 · John Kerski

SQLBI YOUTUBE CHANNEL