RELATED and RELATEDTABLE in DAX | Power BI Tutorial
In this Power BI tutorial, Justin Vogel from Pragmatic Works teaches how to use the DAX functions RELATED and RELATEDTABLE to work with data across multiple tables. He explains how one-to-many relationships enable these functions, with RELATED operating as a model-aware VLOOKUP while RELATEDTABLE is effective when used with iterator functions like COUNTROWS, SUMX, and AVERAGEX. The video demonstrates practical examples, such as integrating customer details into the orders table, correctly counting orders per customer, and calculating total and average sales per order, emphasizing the importance of avoiding common DAX mistakes. The tutorial includes examples of good and bad column designs related to row context and filtering, helping viewers to apply these concepts effectively in Power BI.
Video 2m
Login now to access my digest by 365.Training
Learn how my digest works
Features
- Articles, blogs, podcasts, training, and videos
- Quick read TL;DRs for each item
- Advanced filtering to prioritize what you care about
- Quick views to isolate what you are looking for right now
- Save your favorite items
- Share your favorites
- Snooze items you want to revisit when you have more time