DAX (Day 2), with Jessica Jolly

DAX (2-Day Session)

with Jessica Jolly

Data Quilter specializing in Microsoft Fabric

The purpose of these training days is to give participants a working knowledge of DAX to create calculated columns, measures, tables, security roles. Participants will also understand and use filter and row context. Learners will be versed in the syntax and principles of the DAX language. They will have hands-on experience writing and de-bugging DAX expressions. They will be exposed to the mechanics of the VertiPaq engine. They will also be introduced to external tools that can help with DAX de-bugging and performance measurement such as DAX Studio and Tabular Editor.

Students will be able to use a variety of DAX functions fluently, including, but not limited to:

• 1. SUMMARIZE, SUMMARIZECOLUMNS, ADDCOLUMNS
  2. FILTER, VALUES
  3. CALCULATE, CALCULATETABLE
  4. SUM, AVERAGE, COUNT and the iterative versions of these functions