ViewTube

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

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

Possible optimization approaches to improve the performance of nested iterators 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 ...

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

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

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

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

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

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

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

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

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

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

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

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

DAX Lib is an open-source repository of User-Defined Functions (UDFs) for Power BI, Fabric, and Analysis Services. Learn how ...

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

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