SQLBI Newsletter #212

NEW ARTICLE

This article describes how to return BLANK instead of zero in a DAX measure. Using this technique, you can remove rows in a Power BI matrix visual where the result of a measure is zero.
Read more

DAX PATTERNS

Budget

This pattern includes several coding techniques you may find useful for budgeting scenarios.

#212 · Mar 2022

LEARNING

Course calendar

Mastering DAX

	Mar 29-31 - Charlotte
	Apr 4-6 - Chicago
	May 18-20 - Copenhagen
	May 23-25 - Amsterdam
	Jun 21-23 - Seattle

Data modeling

	May 23-25 - New York

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
	Power Pivot

The techniques do not apply only to budgeting. We use the budget as an example to show how to reallocate a measure at a different granularity, and how to combine measures coming from tables with different granularities into the same chart.
Read more

BI-WEEKLY NEWS DIGEST

Latest news

	• Dataset backup and restore performance just got a lot better Microsoft made considerable progress in the backup time of datasets in Power BI service. The performance improvements in the restore features are there as well, but only marginal compared to those of backup. Mar 7, 2022 · Microsoft
	• Refreshing Excel Power Query queries with VBA and Power Automate for Desktop You can use Power Automate to execute (or delete) individual Power Query queries. This article is interesting for two reasons: the use case of Power Automate, and the VBA functions introduced in Excel a few months ago. Feb 27, 2022 · Chris Webb

SQLBI YOUTUBE CHANNEL

Latest videos

DAX by examples