SQLBI Newsletter #236

NEW ARTICLE

Understanding blank row and limited relationships

DAX creates a blank row to guarantee that results are accurate even if a regular relationship is invalid. The blank row is not created for limited relationships. This article shows the effect of not having a blank row in your tables.
Read more

DAX PATTERNS

Comparing different time periods

This pattern is a useful technique to compare the value of a measure in different time periods. For example, we can compare the sales of the last month against a user-defined period.

#236 · Feb 2023

LEARNING

Course calendar

Mastering DAX

	Feb 28-Mar 2 - Amsterdam
	Mar 21-23 - Dallas
	Apr 17-19 - Copenhagen
	May 22-24 - Chicago
	Jun 14-16 - Perth
	Jun 20-22 - Sydney
	Jun 26-28 - Brisbane
	Jun 27-29 - Amsterdam

Data modeling

	Apr 18-20 - 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

The two time periods might have a different number of days, like comparing one month against a full year. When the durations of both time periods are different, we should adjust the values to make a fair comparison.
Read more

BI-WEEKLY NEWS DIGEST

Latest news

	• Passing any arbitrary value from a Power BI report to a dynamic M parameter There is a way to enter any value (and not just a slicer selection) in an M parameter. This is helpful to create dynamic requests for DirectQuery. Feb 9, 2023 · Chris Webb
	• Hacking a bar chart into a table in Power BI You can create a bar chart in a cell of a Power BI table by using SVG measure, extended Unicode characters, and conditional formatting. The last one requires more creativity! Jan 2, 2023 · Darren Gosbell

SQLBI YOUTUBE CHANNEL

Latest videos

Introducing window functions in DAX

40:58

#article

Alberto Ferrari

Counting consecutive days with sales - Unplugged #47

13:52

#unplugged

Alberto Ferrari

Welcome to SQLBI+

06:54

#announcement

Marco Russo

View Web Version · Status & 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.