This section contains release notes for the DAX Optimizer engine. When a new version of the engine is released, it is a good idea to re-run the optimizer on your models to take advantage of the latest improvements.
-
v1.9.8
Oct 21, 2025Bug Fixes
- Fixed an issue in the evaluation of the
SUMMARIZECOLUMNSfunction that could cause model analysis to fail
- Fixed an issue in the evaluation of the
-
v1.8.29
Apr 24, 2025New Features
- Added support for Calculation Item analysis.
- Added support for Table Permission (RLS) analysis.
- Added new rule for
DIVIDEused instead of the division operator/.
Bug Fixes
- Fixed an issue where certain DAX functions were incorrectly identified as duplicates, such as volatile functions.
Other Enhancements
- Improved analysis and estimation of scalar predicates and filter arguments.
- Improved analysis and estimation of columns where the
IsAvailableInMDXproperty is set tofalse.
-
v1.7.47
Feb 07, 2025Bug Fixes
- Fixed an issue in estimating the materialization of nested iterators that could cause the model analysis to fail.
-
v1.7.46
Feb 03, 2025Bug Fixes
- Fixed an issue in the evaluation of the
GROUPBYfunction where an empty input table (zero cardinality) could cause model analysis to fail.
- Fixed an issue in the evaluation of the
-
v1.7.45
Jan 17, 2025Bug Fixes
- Fixed an issue in the evaluation of
FIRST/LASTNONBLANKfunctions, where using a column reference as theColumnNameargument could cause model analysis to fail.
- Fixed an issue in the evaluation of
-
v1.7.44
Dec 16, 2024Bug Fixes
- Fixed an issue in cardinality estimation of grouping functions where having all grouping columns with zero cardinality (from empty tables) could cause model analysis to fail.
-
v1.7.41
Dec 05, 2024Bug Fixes
- Fixed an issue in the evaluation of
DETAILROWSwhen used as a filter argument inCALCULATEorCALCULATETABLE, which could cause the model analysis to fail.
- Fixed an issue in the evaluation of
-
v1.7.40
Dec 03, 2024Bug Fixes
- Fixed an issue in the evaluation of
EXTERNALMEASUREthat could cause a measure to be incorrectly reported as faulty.
Other Enhancements
- Internal engine performance improvements.
- Fixed an issue in the evaluation of
-
v1.7.35
Nov 28, 2024Bug Fixes
- Fixed an issue in the evaluation of
SUMMARIZEwhere using grouping columns with zero cardinality (from empty tables) could cause model analysis to fail.
Other Enhancements
- Internal engine performance improvements
- Fixed an issue in the evaluation of
-
v1.6.9
Sep 27, 2024Bug Fixes
- Fixed an issue in the evaluation of
MATCHBYthat could cause a failure in model analysis.
- Fixed an issue in the evaluation of
-
v1.6.7
Sep 24, 2024New Features
- Added rule detection for
FIRSTDATEandLASTDATEwhen used to return a scalar value.
Bug Fixes
- Fixed an issue in the evaluation of
SUMMARIZECOLUMNSthat could cause a failure in model analysis.
- Added rule detection for
-
v1.5.12
Sep 20, 2024Bug Fixes
- Fixed an issue in the evaluation of
HASONEVALUEthat could cause a failure in model analysis.
- Fixed an issue in the evaluation of
-
v1.5.10
Sep 02, 2024New Features
- Added rule detection for
ANDcondition between different columns in scalar predicate filter arguments.
Other Enhancements
- Improved cardinality estimate and impact analysis for scalar predicate filter arguments.
- Added rule detection for
-
v1.2.6
Jun 27, 2024New Features
- Improved analysis and estimation of expressions containing dead code, such as unreferenced variables.
-
v1.1.6
Jun 04, 2024New Features
- Added rule detection for
FILTERused as an iterator instead of modifying the filter context with the minimal number of column filters - Added rule detection for context transitions within an iterator over a table with non-unique rows
- Added rule detection for
-
v0.5.5
Mar 07, 2024Bug Fixes
- Fixed error when a non-physical column is used in a scalar predicate
-
v0.5.1
Dec 21, 2023New Features
- Added rule detection related to
IFused in iterators
- Added rule detection related to
-
v0.4.27
Oct 03, 2023Bug Fixes
- Fixed error when
SWITCHis used as a scalar predicate
- Fixed error when
-
v0.4.26
Sep 21, 2023New Features
- Updated DAX syntax to support new parameters in window functions
-
v0.4.25
Sep 14, 2023Bug Fixes
- Fixed error in estimation caused by missing lineage in column reference
-
v0.4.24
Sep 03, 2023Bug Fixes
- Fixed error caused by
PARTITIONBY - Ignored DumpFilter measures generated by DAX Studio
- Fixed error caused by
-
v0.4.22
Aug 31, 2023Bug Fixes
- Estimates columns cardinality when at zero in VPAX metadata
- Fixed issues in duplicated functions detection and
NaNresults
Other Enhancements
- Internal engine performance improvements
-
v0.4.14
Aug 22, 2023Bug Fixes
- Fixed
ORDERBYcardinality estimate error
- Fixed
-
v0.4.13
Aug 02, 2023Bug Fixes
- Fixed
ALLCROSSFILTEREDcardinality estimate error
Other Enhancements
- Updated VPAX libraries to 1.3.0
- Fixed