Sign in with Microsoft
New to Microsoft? Create an account.


Assume that you use SQL Server 2017 Analysis Service (SSAS 2017).  TREATAS function Data Analysis Expressions (DAX) query does not work when the columns it uses are not processed. This improvement adds a new feature IsAvailableInMDX that can disable processing for specific columns to make sure that TREATAS function DAX query work in such columns.

Note The performance will be lowered a bit when you run the query with this feature.


This improvement is included in the following cumulative update for SQL Server:

About cumulative updates for SQL Server:

Each new cumulative update for SQL Server contains all the hotfixes and security fixes that were included with the previous cumulative update. Check out the latest cumulative updates for SQL Server:


Learn about the terminology that Microsoft uses to describe software updates.

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

What affected your experience?

Thank you for your feedback!