DAX Function

RELATED Power BI DAX exercises.

These concepts all use RELATED. Work through related PBIX exercises, compare the patterns, and submit numeric answers to save your progress.

View all DAX functions

5Related concepts

Concepts Using RELATED

Creating Dynamic Labels and Tooltips with DAX Measures

Learn to create dynamic labels for card visuals and detailed tooltips for charts using various DAX functions to enhance report interactivity and user experience.

BeginnerRELATED

Enhancing Chart Labels with RELATED and Concatenation in DAX

Learn to use the RELATED function in a DAX calculated column to concatenate related data from multiple tables, creating more informative chart labels.

Filtering Tables with the DAX FILTER Function for Dynamic Calculations

Understand and apply the DAX FILTER function to create filtered tables for other functions, enabling dynamic calculations based on specific conditions.

IntermediateRELATED

Leveraging RELATED for Cross-Table Calculated Columns in DAX

Understand and apply the DAX RELATED function to create calculated columns that retrieve values from related tables, including handling blank values.

IntermediateRELATEDISBLANK

Retrieving Related Data with DAX's RELATED Function

Learn how to use the RELATED DAX function to retrieve values from a related table into a calculated column, and effectively handle cases where no related value is found using ISBLANK.