Working through the webinar one module at a time, you will receive instructions from the instructor, be asked to watch the video, complete a practice session and then return to the Zoom meeting for Q&A with the instructor and to review the module. The instructor will be available in the Zoom meeting for the duration of the day to answer questions.

Advisory: Videos are hosted on the video-sharing platform Vimeo - please ensure your computer, internet and browser settings allow you to access and watch videos hosted on Vimeo as this will be an integral part of the course.

While a well-related model is a core part of making Power Pivot sing, understanding DAX formulas is what really takes your Power Pivot to the next level. This course is intended to help you up your DAX game so that you can make your PivotTables show the exact aggregations you need. From creating simple measures to controlling % of grand totals which don’t lose their context upon filtering, to advanced patterns to control date period intelligence, we’ll cover it here.

If you’ve grown into Power Pivot but haven’t spent time studying DAX to any level of depth, this course is for you. After this course, you’ll be comfortable rolling your own custom measures to make your projects report EXACTLY the way you want.

• review of dimensional modelling terms and techniques and recommended practices
• building basic DAX measures from scratch
• understanding “Filter Context” and how it applies to formula calculation
• debugging a measure
• using CALCULATE() and ALL() to truly master your filter context
• advanced conditional logic patterns
• using iterator functions like SUMX() and AVERAGE()
• advanced time intelligence patterns

Live webinars have varying levels of expected interaction, with some requiring microphone and camera capabilities to support a proper learning experience – please email pdreg@bccpa.ca if you have concerns. 

In general, we encourage participants to have their cameras turned on to enhance their virtual learning experience. This practice promotes a stronger connection with the instructor and fellow participants, and fosters improved communication and collaboration.

Live Webinar FAQs can be found here.  

Registration terms and conditions, including the cancellation policy can be found here. If you require further assistance, please contact the PD Department.