SQLBI Newsletter #276

NEW ARTICLE

One of the few golden rules in DAX is to always filter columns and never filter tables with CALCULATE. This article explains the rationale behind the rule.
Read more

SQLBI REPLAY

Debugging DAX measures in Power BI

This article describes different techniques to debug a DAX measure that returns an incorrect result, with and without external tools.
Read more

#276 · Aug 2024

LEARNING

Course calendar

Mastering DAX - 3 DAYS

	Sep 18-20 - Calgary
	Oct 14-16 - London
	Oct 30-Nov 1 - New York City
	Nov 12-14 - Seattle
	Nov 19-21 - Amsterdam
	Dec 2-4 - Copenhagen

DATA MODELING - 3 DAYS

	Sep 23-25 - Vancouver
	Dec 10-12 - 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
	DAX Patterns

BI-WEEKLY NEWS DIGEST

Latest news

	• Power BI August 2024 updates The relevant feature for Desktop is the preview of the visual level format strings. However, we now have the DAX query view on the web. Not much going on in this summer release! Aug 20, 2024 · Microsoft
	• Monitoring the opening of DirectQuery connections in Power BI Talking about limits in Power BI Service and Fabric, DirectQuery performance can also be affected by the opening of a new connection to the relational database. You can monitor these events with Log Analytics. Aug 11, 2024 · Chris Webb
	• Fabric capacity limits Each Fabric SKU has specific limits for semantic models that are not easy to find in a single table in the Microsoft documentation. This information is useful to evaluate which Fabric capacity can host your semantic model. Aug 14, 2024 · Teo Lachev
	• Tuning Power BI Copilot with Row label and Key column properties Setting all the properties of a semantic model can help Power BI Copilot in producing better reports. Row label and Key column are two properties that control how a business entity is identified on a report. Aug 25, 2024 · Chris Webb

SQLBI YOUTUBE CHANNEL

Latest videos

Highlighting a data point and comparing all others in a distribution

19:19

#article

Kurt Buhler

Row context in DAX explained visually

21:45

#article

Marco Russo

DAX Optimizer 1.2 - new features

12:42

#announcement

Marco Russo

When are variables evaluated in DAX

26:36

#article

Alberto Ferrari

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.