DAX Converter — VS Code Extension
A standalone VS Code extension that converts business expressions and natural language into Power BI DAX formulas.
Features
- Convert Expression — type an expression in the command palette and get the DAX formula.
- Convert Selection — highlight any text in the editor, right-click, and convert it to DAX.
- Local Python converter — runs the bundled
dax_converter.py script.
- Optional remote service — point the extension at a running
dax_service.py instance.
Commands
| Command |
Title |
dax-converter.convertExpression |
DAX Converter: Convert Expression |
dax-converter.convertSelection |
DAX Converter: Convert Selection to DAX |
Settings
| Setting |
Description |
daxConverter.pythonPath |
Path to the Python interpreter. If omitted, the extension searches PATH. |
daxConverter.serviceUrl |
Optional URL of the DAX converter service (e.g. http://localhost:8000). When set, the service is used instead of the local script. |
Examples
| Input |
Output |
total of amount from sales |
SUM(Sales[Amount]) |
CASE WHEN Sales[Amount] > 1000 THEN 'High' ELSE 'Low' END |
IF(Sales[Amount] > 1000, 'High', 'Low') |
running total of amount from sales |
CALCULATE(SUM(Sales[Amount]), FILTER(ALL('Date'[Date]), 'Date'[Date] <= MAX('Date'[Date]))) |
Build and Package
cd dax-vscode-extension
npm install
npm run compile
npm run package
The generated .vsix file can be installed from the Extensions view (... → Install from VSIX).
Run the Optional Service
uvicorn dax_service:app --host 0.0.0.0 --port 8000 --reload
Then set daxConverter.serviceUrl to http://localhost:8000.
| |