Chapter 8: Adding Measures and Calculations with DAX
Now that you have created your tabular models, we will look at expanding the models further using Data Analytic Expressions, or DAX. Like MDX for multidimensional models, DAX is designed for use with Microsoft's VertiPaq engine. While MDX is modeled after SQL (SELECT…FROM…WHERE), DAX was designed for use by business and data analysts already familiar with Excel functions. In some ways, it is a happy medium between Multidimensional Expressions (MDX) and Excel functions. We can use DAX to create columns, measures, and query the database.
In this chapter, you will learn all there is to know about DAX, which will help you to enhance your existing models to meet the business requirements. Without ...
Get Hands-On SQL Server 2019 Analysis Services now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
