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


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

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


Latest videos