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 ... Create a DAX model-independent user-defined function (UDF) to easily apply the -for- pattern to your data. Article and ... A simple daily average can hide complexities and return different values. We explore several edge-case scenarios to build the ... DAX Lib is an open-source repository of User-Defined Functions (UDFs) for Power BI, Fabric, and Analysis Services. Learn how ... When should you use DISTINCT over VALUES in DAX? Here is how to write resilient measures that survive bad data and model ... A DAX calculation can produce convincing values at the detail level and fail at the total. The problem is often that the business rule ... Learning DAX by examples is never a good idea! Watch why and get motivated in learning some theory first! Download sample ... SUMMARIZECOLUMNS is a powerful and complex function in DAX that in 2025 can be used in measures. This article outlines the ... How to apply a different formatting rule at each level of a hierarchy using ISINSCOPE in a measure or ISATLEVEL in a visual ... How to find evergreen products in DAX. Top 10 products are a classic. Reporting which products are in the top ... Learn how to specify the parameter types in DAX user-defined functions using MEASUREREF, COLUMNREF, TABLEREF, and ... The state of AI tools with Power BI, and how to use the model context protocol (or MCP) to interact with and control Power BI or ...