SQLBI
Business Intelligence with passion
- Website
- feeds.feedburner.com · all feeds from this site
- Feed URL
https://feeds.feedburner.com/sqlbi_blog
Read it in your FeedListing reader
Or add to: Feedly Inoreader Raw feed
Latest posts
-
DAX LLM Benchmark v2.0 Trailer
Which LLMs are ready to write DAX? Check it out at https://www.daxbench.com/
-
DAX LLM Benchmark v2
The DAX LLM Benchmark v2 shows that the latest frontier models write DAX very well, and that the model generation matters more than the vendor. This post describes how we built the benchmark, how we read its results, and what…
-
Install DAX libraries into Power BI Desktop by asking your AI assistant
At the end of 2025, we launched DAX Lib, a public repository of DAX user-defined functions. So far, importing a DAX library has required a few manual steps, like clicking Add to Power BI on daxlib.org and then copying and…
-
Continuous axis for any Date table in Power BI
How to get a continuous X-axis at the month level in Power BI with any Date table, like the one we get using the auto date/time feature.
-
Continuous axis for any Date table in Power BI
Power BI enables the continuous X-axis on the auto date/time hierarchy even at the month level. We can get the same behavior on any Date table by setting the right metadata in TMDL. In a previous article, Creating a simpler…
-
Understanding DAX contracts when using AI
Defining the right contract is a key activity for a DAX developer using AI. Here we introduce the concept of a contract through simple examples.
-
Understanding DAX contracts when using AI
Defining the right contract is a key activity for a DAX developer using AI. In this article, we introduce the concept of a contract through simple examples. Contract. As a DAX developer, you will use this term frequently; indeed, when…
-
Start using DAX with AI
The time has come: in 2026, using AI to write DAX has started to be effective. Latest news and the new courses are at https://www.sqlbi.com/ai/ We also created three new video courses that should not become obsolete in two weeks!…
-
The hidden complexity of a daily average in DAX
A simple daily average can hide complexities and return different values. We explore several edge-case scenarios to build the desired calculation using AI to accelerate the development.
-
Where we stand on AI and DAX in 2026
The time has come: in 2026, using AI to write DAX has started to be effective. Let me recap what has changed between 2023 and 2026, and what we are doing with our three new courses to best assist you…
-
The hidden complexity of a daily average in DAX
A simple daily average masks a level of complexity that may not be immediately apparent. In this article, we use AI to create a daily average, and then to analyze several edge-case scenarios to build a sound calculation. Computing an…
-
Writing DAX at the correct granularity
A DAX calculation can produce convincing values at the detail level and fail at the total. The problem is often that the business rule was evaluated at the wrong granularity. This video introduces four grains, or levels of granularity, to…
-
Writing DAX at the correct granularity
A DAX calculation can produce convincing values at the detail level and still fail at the total. The problem is often not the total itself: the business rule was evaluated at the wrong granularity. This article introduces four grains, or…
-
Matrix Totals - The Whiteboard #13
Let's talk about matrix totals in this episode of The Whiteboard! Special guest: the SQLBI Whiteboard! Learn abstract DAX concepts in a more interactive way with "The Whiteboard" series. Read more:…
-
SQLBI Whiteboard
SQLBI Whiteboard is a free, open-source whiteboard for Windows 11 designed for teaching DAX, SQL, and data modeling, with pen ink, live application capture, and syntax-highlighted code on the same canvas. Pen-first ink — Low-latency, pressure-aware strokes with palm rejection,…
-
Testing DAX measures by using AI
How to use AI to identify relevant test cases in a semantic model and create repeatable DAX tests for a measure.
-
Testing DAX measures by using AI
This article describes how to use AI to identify relevant test cases in a semantic model and create repeatable DAX tests for a measure. A DAX measure is correct only when it produces the expected result in every situation of…
-
Creating DAX functions with AI to remove duplicated code
How to leverage AI to refactor existing DAX code, remove duplicated parts, and centralize the common code in user-defined functions.
-
Creating DAX functions with AI to remove duplicated code
Code written by AI can contain many duplicate parts. User-defined functions are a great tool to simplify complex measures; this article shows how to leverage AI to build better DAX code. AI is getting better and better at generating DAX…
-
Restoring alternating rows in Power BI matrices with Fluent 2
Microsoft recently introduced a new default visual design style for Power BI named Fluent 2. I personally disagree with a few choices in the new defaults, including the removal of alternating row colors from Table and Matrix visuals. However, the…