skip to Main Content
Loading Training Classes

Foundations taught us how to remove repetitive, manual work and make impactful insights. Advanced DAX is about making it rain money with better informed decisions!


  • Taught completely in Power BI Desktop.
  • If Foundations is a 101 course, hands-on work experience with DAX is 201, and Advanced DAX is 301.
  • This class will teach you how DAX really works, how to build complex reports that are still digestible, and how to use that information to drive your business.

Who Can Benefit?

  • Students who have previously taken the Foundations Course and have hands on experience with DAX language.
  • Heavy users of Excel PivotTables (or similar data analysis tools)
  • Users with familiarity with foundational DAX functions like CALCULATE and FILTER
  • Note: Persons with Database, BI, Programming, or similar experience are quite qualified to take this course, even if lacking in Excel experience.

What’s Included:

  • Advanced Level DAX distilled into easy to understand patterns to apply to your most difficult business challenges.
  • “Take with you” downloadable Advanced DAX Power Pivot and Power BI workbook samples.


  1. Simple and Complex Filtering
  2. “What the X!?” Function
  3. Cross Join Role Playing
  4. Advanced Table Functions
  5. Complex Data Modeling
  6. Data Model Performance


What should I bring into the event?

Please bring a laptop with PowerBI loaded on your machine.

How can I contact the organizer with any questions?

Please email [email protected] for any questions you may have.

What’s the refund policy?

Refund requests can be done through Eventbrite up to 30 days before class.  After that, you may transfer to another class.
Additionally, PowerPivotPro reserves the right to cancel any training course due to insufficient enrollment at least 30 calendar days in advance of the scheduled course date. Notice will be provided with the option to reschedule for a future course date or to receive a full refund of registration fees.
PowerPivotPro is not responsible for any expenses incurred by the customer if a training course is cancelled.
If a training course is cancelled due to any unforeseen circumstances such as weather or natural disaster, the customer is entitled to reschedule for a future training course.

Level Up Series: Advanced DAX

Washington, DC

August 13, 2019 @ 8:30 am - August 14, 2019 @ 4:30 pm


**Use discount code “3ORMORE” when signing up 3+ people


Serendipity Labs Bethesda
4500 East West Hwy, Ste 125
Bethesda, MD 20814
+ Google Map