© Dan Clark 2017

Dan Clark, Beginning Power BI, 10.1007/978-1-4842-2577-6_5

5. Creating Calculations with DAX

Dan Clark

(1)Camp Hill, Pennsylvania, USA

Now that you know how to create a robust data model to base your analysis on, the next step is to add to the model any calculations required to aid your exploration of the data. For example, you may have to translate code values into meaningful descriptions or parse out a string to obtain key information. This is where Data Analysis Expressions (DAX) comes into play. This chapter introduces you to DAX and shows you how to use DAX to create calculated columns to add to the functionality of your model.

After completing this chapter, you will be able to

  • Use DAX to add calculated columns to a table.

Get Beginning Power BI: A Practical Guide to Self-Service Data Analytics with Excel 2016 and Power BI Desktop, Second Edition 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.