DAX-6 3 (Output 1)_2106-1080-12mbps
0 (0 Likes / 0 Dislikes)
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.