Packt+ | Advance your knowledge in tech

You're reading from Microsoft Power BI Complete Reference Bring your data to life with the powerful features of Microsoft Power BI

Product type Course

Published in Dec 2018

Publisher Packt

ISBN-13 9781789950045

Length 794 pages

Edition 1st Edition

Tools

Power BI

Concepts

Business Intelligence

Authors (5):

Brett Powell

Mitchell Pearson

Brian Knight

Devin Knight

Manuel Quintana

+1 more

View More author details

Table of Contents (25) Chapters

Title Page

About Packt

Contributors

Preface

1. Getting Started with Importing Data Options FREE CHAPTER

2. Data Transformation Strategies

3. Building the Data Model

4. Leveraging DAX

5. Visualizing Data

6. Using a Cloud Deployment with the Power BI Service

7. Planning Power BI Projects

8. Connecting to Sources and Transforming Data with M

9. Designing Import and DirectQuery Data Models

10. Developing DAX Measures and Security Roles

11. Creating and Formatting Power BI Reports

12. Applying Custom Visuals, Animation, and Analytics

13. Designing Power BI Dashboards and Architectures

14. Managing Application Workspaces and Content

15. Managing the On-Premises Data Gateway

16. Deploying the Power BI Report Server

17. Creating Power BI Apps and Content Distribution

18. Administering Power BI for an Organization

19. Scaling with Premium and Analysis Services

1. Other Books You May Enjoy

Leave a review - let other readers know what you think

Index

Building calculated columns

Open the pbix file Chapter 4 – Leveraging DAX from the book files

Calculated columns are stored in the table in which they are assigned, and the values are static until the data is refreshed. You will learn more about refreshing data in a later chapter.

There are many use cases for calculated columns, but the two most common are as follows:

Descriptive attributes
Concatenated key columns

Now you are going to create your first calculated column. Before you get started, though, you need to first know that Power BI Desktop has IntelliSense. IntelliSense will help you out a lot when writing code, as you will discover very soon. This built-in functionality will autocomplete your code as you go, and will also help you explore and discover new functions in the DAX language. In order to take advantage of IntelliSense, you simply need to start typing in the formula bar. Now you are ready to start writing DAX!

Click on the Data View—this is located on the left side of the Power...

The rest of the chapter is locked

You're reading from Microsoft Power BI Complete Reference Bring your data to life with the powerful features of Microsoft Power BI

Table of Contents (25) Chapters

Building calculated columns

Unlock this book and the full library FREE for 7 days

Authors (5)

Personalised recommendations for you