The third use for table functions is to query data in your data model. You can do this from within Excel Power Pivot, or through tools such as SSMS or DAX Studio. In this section, we'll look at examples of using all three tools.
A DAX query consists of the EVALUATE statement, followed by a table expression. This table expression can simply be a table name, or it can be a more complex example, such as the one we used in the previous section. The result of executing the EVALUATE statement is returned as a table.
Let's start by looking at how to query data in a data model using Excel. Proceed as follows:
- Open the Excel workbook that we created in Chapter 4, Working with DAX in Power BI, Excel, ...
