ViewTube

Defining the right contract is a key activity for a DAX developer using AI. Here we introduce the concept of a contract through ...

Learn how to use TREATAS in CALCULATE filter arguments. How to learn DAX: https://www.sqlbi.com/guides/dax/?aff=yt The ...

User-defined functions are a new and exciting feature in DAX. Here are the key concepts to understand before using them in ...

A simple daily average can hide complexities and return different values. We explore several edge-case scenarios to build the ...

Understanding the difference between row context and filter context is the first and most important concept to learn to use DAX ...

A visual representation of the filter context in DAX can help understand the conceptual model. Article and download: ...

The time has come: in 2026, using AI to write DAX has started to be effective. Latest news and the new courses are at ...

SUMMARIZECOLUMNS is a powerful and complex function in DAX that in 2025 can be used in measures. This article outlines the ...

Learning DAX by examples is never a good idea! Watch why and get motivated in learning some theory first! Download sample ...

Why you should always filter columns and never filter tables with CALCULATE in DAX! Article and download: ...

How to define optional parameters in DAX user-defined functions and set default values for parameters not specified by the caller.

Learn the differences between similar but different DAX functions that remove filters from the filter context. Article and download: ...

How to apply a different formatting rule at each level of a hierarchy using ISINSCOPE in a measure or ISATLEVEL in a visual ...

Context transition is one of the most obscure topics for DAX newbies. Learn how it works, its effects, and how to leverage it rather ...