In this chapter, we looked at the DAX table functions. We looked at how they can be used to create calculated tables and how they can be used as parameters to functions that require a table expression for a parameter. We learned how to use table functions with Excel, SSMS, and DAX Studio to query data in our data model.
We then moved on to look at those table functions that are classed as table manipulation functions, and how they can be used to manipulate data in our data model. We looked in detail at the CROSSJOIN, DATATABLE, EXCEPT, INTERSECT, UNION, and GENERATESERIES functions.
Finally, we looked at some examples of working with table functions. In particular, we looked at using table functions as parameters to other functions and we worked through some examples of using the COUNTROWS, PRODUCTX, CONTAINS, and CONCATENATEX functions.
In the next chapter, we will continue...
