SKILL.md — SQL to DAX Metric Translation

Purpose

Translate analytical SQL aggregation expressions into equivalent DAX measures.

The goal is semantic equivalence, not syntactic similarity.

The generated DAX should:

• Follow Power BI / Tabular best practices
• Prefer iterator functions when row context is required
• Use DIVIDE instead of / NULLIF(...,0)
• Fully qualify columns using 'table'[column]
• Use CALCULATE where filter context translation is required
• Preserve aggregation semantics exactly
• Avoid SQL constructs unsupported in DAX by rewriting logically