Dynamic Presentation Using Excel CUBE Formulas

on YouTube ↗01h 05m

" summary

Step-by-step demo of building a dynamic, asymmetrical Excel report using CUBEMEMBER/CUBEVALUE/CUBESET against the PowerPivot data model, showing how to auto-populate state and year axes, use CUBERANKMEMBER + ROW/COLUMN to index rows/columns, and switch measures via DAX-calculated measures (actual vs target). Includes slicer integration, MDX EXIST for region→state filtering, conditional formatting to hide blanks, and a working workbook—performance is slower than a single pivot query but caching and the in-memory engine keep it practical.

AI-written summary · about

" chapters (11)

1. 0:00Dynamic Excel CUBE formulas
2. 1:01CUBE functions basics
3. 9:15Static report with CUBE functions
4. 17:05Dynamic report with CUBE functions
5. 30:13Fixing hardcoded references
6. 40:14Fully dynamic report
7. 44:51Adding measures and fields
8. 51:25Conditional formatting
9. 53:12Slicers with CUBE functions
10. 55:21Final dynamic report
11. 57:49Q&A

" related talks

• 01h 00mMastering the CUBE Functions in Excel 2013Peter Myers · PASS Business Analytics Conference 2013
• 43mFrom Power BI to Excel - The best of two worldsPedro Reis · Global Azure Virtual 2021
• 58mProductivity Revolution in ExcelAvi Singh, Purna Duggirala · PASS BA Marathon 2015
• 47mFrom Power BI to Excel - The best of two worldsPedro Reis · Global Azure 2021
• 25mTake your Power BI Reports to the Next LevelIndira Bandari · Power BI Women Summit 2021
• 50mLet End Users Drive: Empowering User Control in Power BI ReportsCristian Angyal · SQLBits 2024
• 01h 01mExcel Charting TipsWayne Winston · PASS Business Analytics Conference 2013
• 45mMagnificent 7 - Simple Tricks to boost your Power BI DevelopmentNikola Ilic · Power Platform Virtual Conference 2021