SQLBI Newsletter #267

NEW ARTICLE

Comparing cumulative values for events in different periods

This article describes how to compare time series that occur over different time periods, by standardizing the timelines to days since a specific event.
Read more

ANNOUNCEMENT

Optimizing DAX completed

With the last section about Composite Models, the second edition of Optimizing DAX is complete.

40 hours of lectures in the video course and a book of 800 pages divided in 22 chapters, organized in 5 sections.

Videos available now, books starting April 30.
Read more

#267 · Apr 2024

LEARNING

Course calendar

INTRO TO DAX - 1 DAY

	Apr 30 - Chicago
	May 27 - Amsterdam

Mastering DAX - 3 DAYS

	May 6-8 - Seattle
	May 14-16 - Hamburg
	May 22-24 - Copenhagen
	Jun 25-27 - Chicago
	Aug 6-8 - Melbourne
	Aug 12-14 - Sydney
	Aug 19-21 - Brisbane

ADVANCED DAX - 1 DAY

	May 1 - Chicago
	May 28 - Amsterdam

DAX OPTIMIZATION - 1 DAY

	May 2 - Chicago
	May 29 - Amsterdam
	Aug 9 - Melbourne
	Aug 15 - Sydney

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 AUSTRALIA

Courses and SQLBI Days in Australia

Marco will be in Australia in August 2024!

Melbourne - bundle available!
- Aug. 6-8: Mastering DAX
- Aug. 9: First Steps in DAX Optimization
Sydney - bundle available!
- Aug. 12-14: Mastering DAX
- Aug. 15: First Steps in DAX Optimization
Brisbane
- Aug. 19-21: Mastering DAX

Mastering DAX and SQLBI Days Australia 2024

BI-WEEKLY NEWS DIGEST

Latest news

	• Power BI April 2024 udpate This release offers small improvements and one new feature: the Copilot pane in Power BI Desktop. Yes, it always requires a Premium or Fabric capacity. Premium per user is not enough. Apr 9, 2024 · Microsoft
	• Validate semantic model relationships Test that your relationships are set up and work as you would expect in your semantic model, so to reduce report errors and possible performance issues. Apr 4, 2024 · Kurt Buhler
	• Introducing a two-layer approach in DAX calculations An introduction to the visual calculations from one of the language designers. To make it clear that a visual calculation is, indeed, only to compute calculations for the visuals! Apr 17, 2024 · Jeffrey Wang
	• Fabric is a team sport If you are overwhelmed by the volume of information about Fabric, you should not think that you must know everything. You cannot, and you would not use all those features. Use this article to convince whomever may not be from a technical background and may suffer from this misperception. Apr 16, 2024 · Kurt Buhler
	• Bravo for Power BI 1.0.8 If you already use Bravo for Power BI, you have already received the notification about the new version. Many fixes, and the more updated VPAX library. If you do not have Bravo, now is the right time to get it! Apr 12, 2024 · SQLBI
	• Tabular Editor 2.24 The latest version of Tabular Editor supports the latest compatibility level, which is required for new Calculation Groups properties to manage multiple selections and no selection. We have new articles to write about these properties... Apr 9, 2024 · Daniel Otykier
	• SQL Server Management Studio 20.1 There is one tool that you need to get SQL Profiler and manage Analysis Services or Power BI through XMLA endpoint: SQL Server Management Studio. It's time to update to version 20! Apr 9, 2024 · Microsoft

SQLBI YOUTUBE CHANNEL