Welcome To Sqlbi

Summary

SQLBI+ is our new subscription service to advanced content that support professional model authors who create semantic models ... The time has come: in 2026, using AI to write DAX has started to be effective. Latest news and the new courses are at ... A simple daily average can hide complexities and return different values. We explore several edge-case scenarios to build the ... Should you use DAX user-defined functions (UDF) or calculation groups? Learn when to use either, and how they complement ... Create a DAX model-independent user-defined function (UDF) to easily apply the -for- pattern to your data. Article and ... DAX Lib is an open-source repository of User-Defined Functions (UDFs) for Power BI, Fabric, and Analysis Services. Learn how ... How to use AI to identify relevant test cases in a semantic model and create repeatable DAX tests for a measure. Article and ... A DAX calculation can produce convincing values at the detail level and fail at the total. The problem is often that the business rule ... Understanding the difference between row context and filter context is the first and most important concept to learn to use DAX ... How to apply a different formatting rule at each level of a hierarchy using ISINSCOPE in a measure or ISATLEVEL in a visual ... A recap of the news in the DAX and Context transition is one of the most obscure topics for DAX newbies. Learn how it works, its effects, and how to leverage it rather ...