Model design, DAX and dynamic formatting

DP-600 · Implement and manage semantic models · Updated

Build a star schema, set relationships and column properties, and write DAX with variables, CALCULATE and dynamic format strings.

This lesson is part of full DP-600 access

The first 2 DP-600 lessons are free. Full access opens every lesson with its practice questions, and the exam-style DP-600 question bank.

In this lesson
  • Star schema
  • Tools to edit and inspect models
  • DAX essentials
  • Dynamic format strings and field parameters
  • Calculation groups
  • Exam traps
  • Practice questions

Get full access Try the free practice exam Log in

DP-600 course outline

All 6 lessons · Course overview
  1. Git integration and deployment pipelines in FabricMaintain a data analytics solution Free
  2. Workspace roles, XMLA endpoint and monitoring in FabricMaintain a data analytics solution Free
  3. Lakehouse or warehouse and loading data in FabricPrepare data Full access
  4. Delta tables, Spark and Power Query transformationsPrepare data Full access
  5. Direct Lake and storage modes for semantic modelsImplement and manage semantic models Full access
  6. Model design, DAX and dynamic formattingImplement and manage semantic models Full access