SQLBI Newsletter #231

NEW ARTICLE

Solving errors in CALCULATE filter arguments

The filter arguments in CALCULATE can be written as logical conditions with certain restrictions.
This article explains the more common errors in these conditions, often described as an anomaly in a True/False expression, and how to solve them.
Read more

#231 · Dec 2022

LEARNING

Course calendar

Mastering DAX

	Feb 28-Mar 2 - Amsterdam
	Mar 15-17 - San Francisco
	Mar 21-23 - Dallas
	Apr 17-19 - Copenhagen
	Jun 27-29 - Amsterdam

Data modeling

	Dec 5-7 - Amsterdam
	Apr 18-20 - 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
	Power Pivot

BI-WEEKLY NEWS DIGEST

Latest news

	• Paginated Reports available in Power BI Pro You read it right: very soon, Premium will no longer be a requirement to access Paginated Reports in Power BI! Which means that you have another good reason to improve your DAX query writing skills. Nov 14, 2022 · Microsoft
	• Using field parameters in Paginated Reports The field parameter function has been designed for Power BI, but you can use it also in Paginated Reports by using a dynamic expression that generates the DAX query. Nov 22, 2022 · Darren Gosbell
	• Power BI November 2022 updates The icon color didn't change, but yellow is no longer the accent color of Power BI: teal is the new color for accessibility reasons. But this month there are many other small updates on field parameters, Azure maps, composite models, and small multiples charts. Nov 29, 2022 · Microsoft
	• Data Gateway November 2022 update Your usual reminder to update your gateway with the monthly update. Nov 29, 2022 · Microsoft
	• Power BI Analyze-in-Excel Checklist Make sure that your dataset is in good shape to use the Analyze in Excel feature in Power BI! Nov 15, 2022 · Kurt Buhler
	• How much data can you load into Power BI? Dataset size, memory size, Premium capacity, large dataset format, and several best practices: all the factors that can affect how much data can be loaded in a Power BI dataset - in a single article. Nov 21, 2022 · Chris Webb

SQLBI YOUTUBE CHANNEL