Home > Store

Part X: DAX Calculated Fields, Downloadable Version

Part X: DAX Calculated Fields, Downloadable Version

Downloadable Video

  • Your Price: $28.04
  • List Price: $32.99
  • About this video
  • Accessible from your Account page after purchase. Requires the free QuickTime Player software.

    Videos can be viewed on: Windows 8, Windows XP, Vista, 7, and all versions of Macintosh OS X including the iPad, and other platforms that support the industry standard h.264 video codec.

Additional sample videos, individual lessons and other formats are available here.

Register your product to gain access to bonus material or receive a coupon.

Audio & Video

Your browser doesn't support playback of this video. Please download the file to view it.

Actual product comes full screen and in high resolution.


  • Copyright 2013
  • Edition: 1st
  • Downloadable Video
  • ISBN-10: 0-13-348024-0
  • ISBN-13: 978-0-13-348024-5

Data Analysis Expressions! DAX is a new function language that's used with PowerPivot, PowerView, and GeoFlow. It makes Calculated Fields in PivotTables look sophomoric., The problem is, it's hard to learn. It's like going to the dentist. Everyone knows they have to do it, they just dont want to do it. Well, in these lessons, Bill Jelen gives you enough sample calculated fields, called Measures, to get you started.

DAX Measures

Use DAX Measures to Calculate a Range

Use DAX Measures to un-apply a Filter

Using a Calendar Table for Time Intelligence

Time Intelligence Functions

Disconnected Parameter Tables with FILTER()

Actuals vs Budget

Using IF(VALUES in a Measure

Build Slicers on Lookup Tables

First Initial Slicer (and turning off cross-slicer filtering)

Convert the Pivot Table to Cube Formulas


Submit Errata

More Information

Unlimited one-month access with your purchase
Free Safari Membership