SQLBI Newsletter #279

NEW ARTICLE

Impact of data types in DAX arithmetical calculations

The choice of data types can affect precision and performance because of internal conversions. This article shows how the right choice of data type and DAX code makes a significant difference.
Read more

SQLBI REPLAY

Computing MTD, QTD, YTD in Power BI for the current period

This article describes how to use the DAX time intelligence calculations applied to the latest period available in the data, also known as the “current” period.
Read more

#279 · Oct 2024

LEARNING

Course calendar

Mastering DAX - 3 DAYS

	Oct 14-16 - London
	Oct 30-Nov 1 - New York City
	Nov 12-14 - Seattle
	Nov 19-21 - Amst
	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

COURSES IN THE US

Mastering DAX in 2024 and 2025

We have already announced the first two Mastering DAX courses for 2025 in the United States, which means we only have a few seats available in New York and Seattle for 2024: hurry and book your seat!

Oct. 30-Nov. 1, 2024: New York City, NY
Nov. 12-14, 2024: Seattle, WA
Feb. 18-20, 2025: Phoenix, AZ
Feb. 24-26, 2025: Dallas, TX

Overall schedule

BI-WEEKLY NEWS DIGEST

Latest news

	• Power BI September 2024 Update Dark mode, live edit of Direct Lake models in Power BI Desktop, and visual level format strings are the more interesting features between the many released this month. Our favorite? The light mode, different from the default theme and available thanks to the work performed for the dark mode! Sep 24, 2024 · Microsoft
	• Managing Power BI reports or models using semantic-link-labs Use semantic-link-labs in a Fabric notebook to streamline a number of report or model management tasks to enhance productivity. Do not miss the internal links to two examples of semantic link usage: recovering reports or models that cannot be downloaded from the Power BI service, and modifying multiple visuals/pages/reports at once. Oct 1, 2024 · Kurt Buhler
	• What is Power Query’s time zone? So you thought that DAX had a particular way of managing time zones once you publish a model? Power Query would say "Hold my beer". Great insights to control your transformations of date and time in your models. Oct 3, 2024 · Daniil Maslyuk
	• What can you do with Copilot in DAX Query View? If you have never had a chance to use Copilot in Power BI, here Chris shows you what it can do in the DAX Query View. It's a fair review. And we have to say - explaining what an existing DAX measure does is probably the more interesting feature for newbies. Sep 22, 2024 · Chris Webb
	• Update to Direct Lake documentation In April 2024, Marco published a blog post describing Direct Lake vs. Import mode in Power BI. We are happy to see that Microsoft has improved their documentation, thus addressing several of the misconceptions created by the initial announcement - the announcement that Marco was referring to in the blog post. The sections Considerations and limitations and Comparison to other storage modes should finally bury the "best of both worlds" announcement we saw on some over-enthusiastic slides. Oct 2, 2024 · Microsoft
	• Field parameters in Analysis Services models Yes, you can create field parameters in a model published on Analysis Services. It also works on SQL Server Analysis Services 2017 on-premises! Sep 20, 2024 · Owen Auger

SQLBI YOUTUBE CHANNEL