Additional sample videos, individual lessons and other formats are available here.
Register your product to gain access to bonus material or receive a coupon.
Actual product comes full screen and in high resolution.
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.
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