Create and Use Calculated Columns in Power Pivot

No reviews yet.

In Power Pivot you can create calculated columns to add new data to tables. Calculated columns use a Data Analysis Expression (DAX) formula and can be applied in PivotTables, PivotCharts and reports.

A DAX is a formula language allowing you to define custom calculations for Calculated Columns in a Data Model.
DAX includes functions similar to those used in Excel formulas and additional functions designed to work with relational data.

Highlights

Create a calculated column in a Data Model
Add a calculated field to a PivotTable
Delete a calculated field

Duration: 6mins 23secs

$6.99 AUD

from

$9.99

Add to Cart

Includes:

Quality On-demand Video Demonstrations
Step-by-step Learner Guide
Demonstration and practice exercises to boost retention
Lifetime access
Course progress indicator

Create and Use Calculated Columns in Power Pivot

Highlights

Related Courses

Add Excel Tables to a Data Model in Power Pivot

Formula Auditing

Understand the Data Model in Power Pivot

Linking Techniques in Depth in Excel

Intermediate Functions in Excel (Level 2)

Automatic Series and Custom Lists

$6.99 AUD

$9.99

Includes: