SQLBI Newsletter #282

NEW ARTICLE

Computing open orders with visual calculations in DAX

This article describes the use of visual calculations for a scenario where they may be particularly relevant: computing open orders at the end of a time period.
Read more

#282 · Nov 2024

LEARNING

Course calendar

Mastering DAX - 3 DAYS

	Dec 2-4 - Copenhagen
	Feb 11-13 - Amsterdam
	Feb 18-20 - Phoenix
	Feb 24-26 - Dallas

DATA MODELING - 3 DAYS

	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

ANNOUNCEMENT

Black Friday 2024

The best shopping day of the year is around the corner. Don't miss our special discounts by visiting the SQLBI website on Nov 29, 2024!

BI-WEEKLY NEWS DIGEST

Latest news

	• Power BI November 2024 update Many new features in preview this month: metric sets, small multiples for new card visual, text slicer, TMDL extension for Visual Studio Code. There are also incremental improvements for other features, like DAX Query View. Perhaps, no big news - but it would have been unusual to see big announcement the week before a large conference such as Microsoft Ignite! Nov 12, 2024 · Microsoft
	• Direct Lake memory: hotness, popularity & column eviction Large semantic models in Import mode use the same eviction technique used in DirectLake. This article shows how to get the temperature of the columns in memory, so you can figure out the columns that are more likely to be evicted from a model when there is not enough memory, with additional consideration for the transcoding cost paid by DirectLake every time a column is loaded in memory. Nov 4, 2024 · Paul Turley
	• Different ways to replace blanks with zeros in DAX Replacing blanks with zeros in a report can be helpful but also dangerous for performance. This article clarifies how to evaluate the differences between several techniques to achieve the same goal, including visual calculations. Which one is better? As usual, "it depends". Nov 3, 2024 · Chris Webb

SQLBI YOUTUBE CHANNEL

Latest videos

Building bullet charts in Power BI reports

33:19

#article

Kurt Buhler

Using weekly calendars in Power BI

41:01

#article

Marco Russo

Impact of data types in DAX arithmetical calculations

20:02

#article

Alberto Ferrari

Collaborate with your Team and Customers with DAX Optimizer

01:50

#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.