In this chapter, we will look at the three different platforms that support DAX – Power BI Desktop, Excel Power Pivot, and SQL Server Analysis Services (SSAS) Tabular. By the end of this chapter, you will be familiar with using the DAX formula editor in Power BI Desktop. You will also have learned how to load data into an Excel Power Pivot data model and expand it using DAX formulas. Finally, you will learn how to use DAX with SSAS Tabular, import the data model from Excel Power Pivot, and use DAX to query the data in SSAS.
The chapter is broken down into the following sections:
- Working with DAX in Power BI Desktop
- Working with DAX in Excel Power Pivot
- Working with DAX in SSAS Tabular
