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 the differences between similar but different DAX functions that remove filters from the filter context. Article and download: ...

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

A DAX calculation can produce convincing values at the detail level and fail at the total. The problem is often that the business rule ...

How to use AI to identify relevant test cases in a semantic model and create repeatable DAX tests for a measure. Article and ...

How to leverage AI to refactor existing DAX code, remove duplicated parts, and centralize the common code in user-defined ...

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

How to highlight a row based solely on the maximum value in the last column using visual calculations, a tool that can be used ...

A complete tour of DAX Optimizer, the tool to improve your DAX code's performance, scalability, and readability. Try the free ...

This video introduces the new calendar-based time intelligence functions in DAX, available in preview from the September 2025 ...

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

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.

Best practices for deciding when to use (and when not to use) KEEPFILTERS in CALCULATE filter arguments. Article and ...

Direct Lake + Import composite mode explained—architecture, performance tests, and where it outperforms pure Import or Direct ...

How the value filter behavior works in SUMMARIZECOLUMNS and how to use it correctly. Article and download: ...

Use visual calculations for a scenario where they may be particularly relevant: computing open orders at the end of a time period.

Is it better to build a model as a regular star schema or as a single table in Power BI? The answer is clear: a star schema is always ...

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