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

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

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

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

Learn the difference between using VALUES and KEEPFILTERS in CALCULATE. How to learn DAX: ...

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

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

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

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

ALL: Returns all the rows in a table, or all the values in a column, ignoring any filters that might have been applied.

VertiPaq Analyzer provides information about storage structures for a data model in Power BI and Analysis Services. It is fully ...

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

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

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

Computing the rolling 12-months average in DAX looks simple, but it hides some level of complexity. This article explains how to ...

Improve DAX queries by using GENERATE and ROW instead of ADDCOLUMNS when you create table expressions. Article and ...

NATURALINNERJOIN: Joins the Left table with right table using the Inner Join semantics. https://dax.guide/naturalinnerjoin/ ...

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

When should you use DISTINCT over VALUES in DAX? Here is how to write resilient measures that survive bad data and model ...