Profile My skills Saved Collections Edit profile Submit a skill

Dax Translation

DAX to SQL/UC-metric-view translation patterns. Use when converting Power BI DAX measures to SQL aggregations or metric view YAML measure expressions. Covers CALCULATE, FILTER, DIVIDE, SWITCH, ALLSELECTED, time intelligence, SELECTEDVALUE, and common untranslatable patterns.

databrickslabs 1ce3e94 4 files · 25.7 KB Updated
Data & Analytics

File contents

DAX to SQL Translation for Metric Views

Translation Decision Framework

For each DAX measure, classify it into one of these categories:

  1. Translatable (direct): SUM, COUNT, AVERAGE, MIN, MAX on columns -> atomic measure.
  2. Translatable (composed): DIVIDE, ratio of measures -> composed measure using MEASURE().
  3. Translatable (filtered): CALCULATE(SUM(...), FILTER(...)) -> measure with FILTER (WHERE ...) clause.
  4. Architecture change needed: SWITCH/SELECTEDVALUE slicer patterns -> replace with dimensions.
  5. Dashboard-layer: ISFILTERED, CONCATENATEX, FORMAT, NAMEOF -> skip, document as display-only.
  6. Not translatable: ALLSELECTED, USERELATIONSHIP, certain time-intelligence -> flag for review.
  7. Out of scope: EXTERNALMEASURE, DirectQuery references -> flag.

For the complete pattern catalog, read PATTERNS.md. For patterns that cannot be translated, read UNSUPPORTED.md. For edge cases and gotchas, read EDGE_CASES.md.

databrickslabs/kasal/tree/main/src/backend/src/engines/crewai/tools/custom/metric_view_utils/skills/dax commit 1ce3e94c3b

Browse category

Frequently asked questions

npx skillmds@latest add databrickslabs/dax-translation