DAX for Power BI installs statistics

DAX Language - Syntax Highlighting, Formatting & Diagnostics

The DAX extension provides comprehensive support for Power BI's Data Analysis Expressions (DAX) language, including syntax highlighting, code formatting, and real-time error detection.

DAX 扩展为 Power BI 的数据分析表达式 (DAX) 语言提供全面支持，包括语法高亮、代码格式化和实时错误检测。

Features

1. Syntax Highlighting

• Full syntax highlighting for DAX language • Supports .dax file extension • Works in Markdown code blocks (DAX, dax, Dax） • 高亮显示函数、关键字、字符串、注释和运算符

1. 代码格式化

• 一键格式化代码（Cmd+Shift+F / Ctrl+Shift+F） • 右键选择命令 "Format Document" • 自动缩进嵌套函数 • 在运算符周围添加空格 • 保留注释和空行

1. 实时诊断

• 检测中文字符（括号、逗号、全角空格） • 检查括号和方括号是否匹配 • 识别未闭合的字符串 • 用红色下划线显示错误信息

Usage Examples

Before Formatting:

After Formatting:

Error Detection:

The extension will highlight errors like: • Chinese parentheses: CALCULATE（SUM([Sales])） ❌ • Chinese comma: CALCULATE(SUM([Sales])，FILTER(...)) ❌ • Unmatched parentheses: CALCULATE(SUM([Sales]) ❌

Installation

1. Install from VS Code Marketplace 2. Open any .dax file 3. The extension will activate automatically

Commands

• Format DAX Document: Format the current DAX file • Keyboard: Cmd+Shift+F (Mac) / Ctrl+Shift+F (Windows) • Command Palette: Format DAX Document

Requirements

• VS Code 1.29.0 or higher

Release Notes

Version 0.1.1 (2026-02-26)

• Fixed formatter bugs for improved code formatting quality

Version 0.1.0 (2026-02-23)

• Updated to 2026-02 DAX function list (466 functions total, +21 new functions) • Added 8 week-related time intelligence functions • CLOSINGBALANCEWEEK, DATESWTD, ENDOFWEEK, STARTOFWEEK • NEXTWEEK, PREVIOUSWEEK, OPENINGBALANCEWEEK, TOTALWTD • Added 11 type checking functions • ISBOOLEAN, ISCURRENCY, ISDATETIME, ISDECIMAL, ISDOUBLE • ISINT64, ISINTEGER, ISNUMERIC, ISSTRING • EXTERNALMEASURE, TABLEOF • Added 2 visual calculation lookup functions • LOOKUP, LOOKUPWITHTOTALS • Added syntax highlighting support for Markdown editor and Markdown Preview • Added code formatting with automatic indentation and operator spacing • Added real-time diagnostics for Chinese characters and syntax errors

Version 0.0.13 (2025-03-18)

• Updated to 2025 DAX function list (445 functions total) • Added 12 visual calculation functions for Power BI visual-level calculations • COLLAPSE, COLLAPSEALL, EXPAND, EXPANDALL • FIRST, ISATLEVEL, LAST, MOVINGAVERAGE • NEXT, PREVIOUS, RANGE, RUNNINGSUM • Enhanced code snippets with function categories (DATETIME, FILTER, WINDOW, etc.) • Added support for financial functions (ACCRINT, DB, XIRR, etc.) • Added support for engineering functions (BITAND, BITOR, BITXOR, etc.) • Added support for system functions (INFO.* series)

Version 0.0.12 (2024-03-22)

• Added visual calculation functions: • COLLAPSE, COLLAPSEALL, EXPAND, EXPANDALL • FIRST, ISATLEVEL, LAST, LOOKUP • MOVINGAVERAGE, NEXT, PREVIOUS • RANGE, RUNNINGSUM

References

• Official DAX Reference • Power BI Documentation

Enjoy coding with DAX! 🚀