SQLBI Newsletter #243

NEW ARTICLE

Introducing dynamic format strings for DAX measures

Power BI introduced dynamic format strings in May 2023. In this article, we briefly introduce this functionality and then dive into a few technical details of its implementation.
Read more

NEW BLOG POST

Generative AI guidelines at SQLBI

We look forward to using AI to improve overall productivity: our productivity and the productivity of our readers. Whenever we publish content generated by AI engines, we will always make that clear to our readers.
Read more

#243 · May 2023

LEARNING

Course calendar

Mastering DAX

	Jun 14-16 - Perth
	Jun 20-22 - Sydney
	Jun 26-28 - Brisbane
	Jun 27-29 - Amsterdam
	Sep 27-29 - Chicago

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

NEW BLOG POST

Explaining REDUCED BY in xmSQL batch events

We recently released the second edition of the Optimizing DAX video course. Despite its volume, there are details that did not make it into the training material. The REDUCED BY syntax of xmSQL is one of those details.
Read more

BI-WEEKLY NEWS DIGEST

Latest news

	• Number of measures matters A good analysis of the impact of the number of measures in a Tabular model. Simple calculations can also be slowed down by thousands of measures. May 6, 2023 · Štěpán Rešl
	• Setting a dynamic default slicer value in Power BI A relatively complex workaround to dynamically set the default slicer value in a Power BI report. May 15, 2023 · Darren Gosbell
	• Power BI automatic refresh retries If a scheduled refresh fails in Power BI service, there are automatic retries. You can analyze what happens in the log and find whether reorganizing the schedule can reduce the risk of hitting the capacity limit. May 14, 2023 · Chris Webb

SQLBI YOUTUBE CHANNEL