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 ...

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

Possible optimization approaches to improve the performance of nested iterators in DAX. Article and download: ...

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

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

SUMMARIZE: Creates a summary of the input table grouped by the specified columns. https://dax.guide/summarize/ This video is ...

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

What is data lineage in DAX? How does it work? How can you write better DAX code knowing it? Article and sample download: ...

Using variables in DAX makes the code easier to read, faster, and easier to debug. Learn how and when to use variables, along ...

This video shows how to use the USERELATIONSHIP function in DAX to change the active relationship in a CALCULATE function ...

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

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

Investigate a slow query in a Power BI report using DAX Studio, looking at the query plan and the server timings. How to learn ...

SUM: Adds all the numbers in a column. https://dax.guide/sum/ SUMX: Returns the sum of an expression evaluated for each row ...

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

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

What are the differences between measures and calculated columns in DAX and Power BI? All the answers in this short video.

This video introduces CALCULATE, the most powerful and complex function in DAX. Article and download: ...