20 - Actual v Budget Dashboard with CUBEFUNCTIONS in Excel - Bernard Obeng Boateng
SumProduct SumProduct
3.01K subscribers
58,488 views
964

 Published On Oct 27, 2021

The goal of this session is to show participants how to create a dynamic Actual v Budget Dashboard with CUBEFUNCTIONS. From just two tables of Actual v Budget data, trainees will make use of Power Query, Power Pivot and CUBEFUNCTIONS to convert the Data into a Dynamic Dashboard that can be sliced by Department, Account Type and Scenario.

Files for the session: https://1drv.ms/u/s!AsVgPBp9qkOCgeEm_...

show more

Share/Embed