SQLBI Newsletter #241

NEW ARTICLE

Rounding errors with different data types in DAX

This article describes the possible rounding differences that may appear in DAX. They are related to the data types and the operation being performed: knowing these details helps you write more robust DAX formulas and avoid comparison errors.
Read more

COMING SOON

We have been busy

Don't miss our next, exceptional newsletter! And do not wait too long if you are interested in a classroom course in June: we are preparing new dates from classroom courses between September and December!
June availability

#241 · Apr 2023

LEARNING

Course calendar

Mastering DAX

	May 17-19 - Seattle
	May 22-24 - Chicago
	Jun 14-16 - Perth
	Jun 20-22 - Sydney
	Jun 26-28 - Brisbane
	Jun 27-29 - 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

	• DAX Studio 3.0.7 released! Many important bug fixes and a few improvements in this new update of DAX Studio. Call to action: install it, then read the release notes if you have time. Yes, just install it. Apr 18, 2023 · Darren Gosbell
	• Power BI April 2023 Update Dynamic format string measures: a long-awaited feature, finally in preview. Plus more updates that deserve their own piece of news. Apr 12, 2023 · Microsoft
	• RANK, ROWNUMBER, and enhanced ORDERBY There are new DAX functions in the April 2023 update: RANK and ROWNUMBER. Yes, RANK is different from RANKX, with important differences for floating point numbers (read the main article of this newsletter to know more). Apr 15, 2023 · Jeffrey Wang
	• Composite models are now generally available In case you forgot, the feature formerly called "DirectQuery for Power BI Datasets and Analysis Services" since December 2020 is now generally available and called "composite models" in the Microsoft documentation - not just over here in the SQLBI world. Thanks Microsoft! Apr 10, 2023 · Microsoft
	• On-premises data gateway April release Your monthly reminder to update your gateway. Apr 19, 2023 · Microsoft
	• Edit your data model in the Power BI Service A dataset published on Power BI can now be edited online. No Power BI Desktop needed. The feature is in preview; there are many limitations, but it's a first step. Apr 20, 2023 · Microsoft
	• Understanding the “A measure is used in cross highlighting” error in Power BI A good explanation of the "Couldn't load the data for this visual" error that describes a limitation of Power BI. Apr 9, 2023 · Chris Webb
	• DAX Pareto calculation using the WINDOW and RANK functions You can create a Pareto analysis in DAX by using the new RANK and WINDOW functions. Apr 17, 2023 · Phil Seamark
	• Disabling filter pane aggregates in Power BI The filter pane aggregates can display useful information (the number of rows for each selection) that is very expensive in DirectQuery mode. A setting in the model can disable it. Apr 16, 2023 · Chris Webb
	• Setting MaxParallelismPerQuery on a Power BI dataset using Tabular Editor It is possible to set the MaxParallelismPerQuery setting in a single dataset. Lower it to decrease memory pressure if your dataset is very large, or you might increase it if you have high latency and many small tables. Or just experiment! Apr 19, 2023 · Darren Gosbell

SQLBI YOUTUBE CHANNEL