CHAPTER 8

Using Calculated Columns and DAX

Up to now in this book, you have used Power BI Desktop with data that is fully ready for analysis. But likely you will often use data sources that require further calculation to derive the key figures you need to analyze the data effectively. You can derive these figures by using the DAX language built into Power BI.

A screenshot exposes the power bi desktop.

Understanding DAX and Why You Should Use It

Add All Numbers in a Column

Perform Division

Check a Condition

Count the Number of Cells in a Column

Return the Average of All Numbers in a Column

Join Two Text Strings into One Text String

Apply Conditional Formatting in Tables

Understanding ...

Get Teach Yourself VISUALLY Power BI 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.