SQLBI Newsletter #265

NEW ARTICLE

Introducing EXPAND and COLLAPSE for visual calculations in Power BI

This article introduces the two basic visual context navigation functions: EXPAND and COLLAPSE.
Read more

NEWS

DAX Optimizer is generally available

DAX Optimizer is now feature complete and ready to improve your DAX code.

Visit the website, create a free account, checkout the samples, and optimize your models!

#265 · Mar 2024

LEARNING

Course calendar

INTRO TO DAX - 1 DAY

	Apr 30 - Chicago
	May 27 - Amsterdam

Mastering DAX - 3 DAYS

	Apr 15-17 - New York City
	May 6-8 - Seattle
	May 14-16 - Hamburg
	May 22-24 - Copenhagen
	Jun 25-27 - Chicago

ADVANCED DAX - 1 DAY

	May 1 - Chicago
	May 28 - Amsterdam

DAX OPTIMIZATION - 1 DAY

	May 2 - Chicago
	May 29 - Amsterdam

Data Modeling - 3 DAYS

	Jul 2-4 - 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

SQLBI+ UPDATE

New content on SQLBI+

We released a new video whitepaper on SQLBI+: Understanding Visual Calculations in DAX!

Visual calculations are a new feature in DAX that aims to simplify the use of DAX for users by introducing calculations at the visual level rather than at the model level.

This paper analyzes the DAX implementation of this feature in depth, including new concepts such as the visual shape and the visual context.

BI-WEEKLY NEWS DIGEST

Latest news

	• Vpax-Obfuscator: a library to obfuscate VPAX files The new Vpax-Obfuscator library obfuscates all the names of columns, measures, and tables of a Tabular semantic model, making the DAX code unreadable to a human but still consistent for tools like DAX Optimizer. Mar 15, 2024 · Marco Russo
	• On-premises data gateway March 2024 release In a week with little news content, the monthly update of the data gateway comes to our rescue! Mar 18, 2024 · Microsoft
	• How much does Copilot cost in Microsoft Fabric? Everybody wants to use Copilot for Power BI, but don't forget to pay the bill! This article sheds some light on how to estimate the cost of Copilot. Mar 17, 2024 · Chris Webb
	• Important update coming to Power BI Premium licensing Power BI Premium per capacity is going to be replaced by Fabric capacity. It does not sound like a substantial change, besides having access to more features. If you have Power BI Pro or Power BI Premium per user (PPU), nothing changes, and you need another license to get Fabric features. Mar 14, 2024 · Microsoft
	• Supporting obfuscation in DAX Optimizer DAX Optimizer now supports obfuscated VPAX files, thus increasing security over model metadata. Mar 20, 2024 · Marco Russo

SQLBI YOUTUBE CHANNEL