Open the app Sign in Start free

DP-600 - Prepare Data - Section 2.9

Select, filter, and aggregate data using DAX queries against a semantic model.

Write DAX queries using EVALUATE and SUMMARIZECOLUMNS to retrieve tabular results from a semantic model. Use CALCULATE to modify filter context and apply measures to aggregate data, distinguishing DAX query syntax from the measure expressions written in the model editor.

DAX queriesEVALUATESUMMARIZECOLUMNSCALCULATEmeasures

More in this domain

Create data connections and manage gateways and credentials to source data into Microsoft Fabric.Section 2.1
Discover data using the OneLake catalog and Real-Time hub and choose between Fabric data stores for a workload.Section 2.2
Ingest or access data using shortcuts, Dataflows Gen2, pipelines, and notebooks, and implement OneLake integration for Eventhouse and semantic models.Section 2.3
Create views, functions, and stored procedures to transform data in a warehouse or the SQL analytics endpoint.Section 2.4
Implement a star schema for a lakehouse or warehouse and enrich data by adding columns or tables, denormalising, and aggregating.Section 2.5
Cleanse and shape data by resolving duplicates, missing values, and null values, converting data types, merging or joining, and filtering.Section 2.6
Select, filter, and aggregate data using the Visual Query Editor and SQL against the SQL analytics endpoint.Section 2.7
Select, filter, and aggregate data using KQL against an Eventhouse or KQL database.Section 2.8

Back to all Prepare Data objectives, or the DP-600 cert hub.

Examworthy is not affiliated with or endorsed by Microsoft. Original, blueprint-aligned practice material only.