DAX Code Formatter

This tool formats DAX expressions used in Power BI, Analysis Services, and SSAS Tabular models. It targets BI developers, data analysts, and data engineers who write measures, calculated columns, and calculated tables. By applying a deterministic set of style rules, it improves readability, reduces cognitive load during code reviews, and promotes consistency across reports. The formatter preserves semantics while reflowing whitespace, indentation, and line breaks to align with a defined standard. It does not execute or validate DAX results.
How it works conceptually: The core engine tokenizes the input, recognizes common DAX constructs (CALCULATE, FILTER, ALL, VALUES, etc.), and reflows code to a consistent layout. Rules include indenting nested expressions, breaking long lines at a configurable max_line_length, aligning operators where feasible, and wrapping function arguments. It preserves comments, literals, and structural elements such as measures, calculated columns, and tables; for deeply nested expressions, depth-aware wrapping is applied.
Value proposition and use cases: Teams gain faster code review, easier knowledge transfer, and standardized formatting suitable for version control and collaboration. Examples include converting a dense multi-line measure into a tidy layout, formatting a block containing several measures pasted from documentation, and preparing code dumps for knowledge bases. Unique differentiators are parser-awareness, batch formatting capability, and adjustable style settings that can be shared across projects, ensuring consistent results across BI workstreams.
Core features and workflow: Input can be a single expression or multiple expressions; options include max line length and indentation size. The tool returns formatted_code and an optional issues list. Use cases cover legacy DAX cleanup, documentation-ready formatting, and team-convention enforcement before deployment. The approach is non-destructive and deterministic, enabling reliable review and faster onboarding for new team members.