Skip to main content

v3.2.1 Release

· 2 min read
Darren Gosbell
Maintainer of DAX Studio

Today we are happy to announce the release of version 3.2.1 of DAX Studio which includes the following new features and fixes.

DSCMD - DAX Parameter Support

If you want to run a DAX query from the command line which has a parameter in it you can now pass a value to be used by that parameter

Both the CSV and XLSX commmands both support passing parameters using the -m, --parameter option.

In the following example the query has 2 parameters @myColor and @myCategory which are passed in using 2 -m options

eg.

dscmd csv c:\temp\myquery.csv -s localhost\tab19 -d "Adventure Works DW"  ^
-m myColor=Red ^
-m myCategory=Bikes ^
-q "EVALUATE FILTER('product', 'product[Color]=@myColor && 'product'[Category]=@myCategory)"

Improved Jumplist Integration

The Jumplist is a feature of Windows 10 & 11 where right clicking on a program in your task bar would show you recently opened files.

Previously this list was only populated when you double clicked on a file that was associated with DAX Studio in Windows Explorer. Now DAX Studio will add items to this list when you open or save files making the Jumplist much more usable since it will be a true reflection of recently used files.

Full Change List

Updates

  • Adding DAX parameter support to CSV & XLSX commands
  • Improved Jumplist integration

Fixes

  • #1292 grid output not binding results with > or & in the column name
  • #1293 Vertipaq Options dialog learn more link broken
  • #1298 Adding Advanced XLSX output settings in Options
  • #1302 Fixing DirectLake mode option not working in View Metrics dialog
  • #1305 All Queries not capturing events
  • #1306 dscmd VPAX command not using default value for StatsColumnBatchSize
  • fixing crash on exit