Working With Expanded Tables In Power BI

For today’s tutorial, we are going to take a look at Expanded Tables, which you’ll most probably have encountered while working with DAX. Expanded Tables are very tricky to work with and they must have messed up you calculations at least once if you haven’t figured out how they are working within your calculation, but they are most certainly fundamental to learn. Antriksh will help you understand how Expanded Tables can impact your calculations and the behavior of using them. ***** Video Details ***** 00:00 Introduction 00:44 Data model 01:47 No. of customers 03:17 Red sales 1 04:40 Red sales 2 05:55 Red sales 3 06:51 Base table vs Expanded table 08:59 How to verify a table expansion 13:39 Slicing categories 14:50 External filter context 18:30 Indirect filer 25:25 Verifying claims ***** Learning Power BI? ***** FREE COURSE - Ultimate Beginners Guide To Power BI - FREE COURSE - Ultimate Beginners Guide To DAX -
Back to Top