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 -