The Data Model and DAX Formulas

Advanced

Microsoft has created a special language to write formulas and measures for PivotTable and Power PivotTable data called DAX. Though remarkably similar to regular Excel formulas, these new functions include filtering in the function and bridging the gap between database languages like SQL and traditional Excel. If you are a Data junkie, we’ll also point you toward Microsoft’s PowerBI.

  1. DAX: Another way to Calculate in Excel
  2. Create a Calculated Column in a PivotTable
  3. Create a Measure in a PivotTable
  4. Aggregate Functions in DAX
  5. Mathematical Functions in DAX
  6. Logical Functions in DAX
  7. Text Functions in DAX
  8. Information Functions in DAX
  9. Filters in DAX
  10. The Road Forward toward PowerBI

Class Length: 1 hour. Can include up to 50 attendees in one session.