DAX-6 3 (Output 1)_2106-1080-12mbps

One of the key differences between DAX and the Excel formula language is that DAX lets you pass whole tables between expressions rather than just individual values. This can be really useful, particularly as it allows you to filter tables down before you do other aggregations on them. Alberto's going to go through this in a bit more detail, about how you can use it to apply filters at different scopes, how you can use it to pull out distinct values from a table, and much more. One of the key things is that it allows you to actually created entirely new calculated tables that can be used just the same way as any other table that, for example, you pulled in from a database. Let's take a look at that in a bit more detail.