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

Link a Chart from Excel to Word

Absolute and Relative References

Hyperlink to Cells External Files and Web Pages

Linking Techniques in Depth in Excel

Data Table Design Rules for Power Pivot

Quick Layout, Color and Chart Style Options

$6.99 AUD

$9.99

Includes: