-
DAX is a functional language that does not allow you to create functions. However, if you need to pass a parameter to an algorithm, you can use a measure passing a value through a filter argument in CALCULATE, as described… Read more
-
This article shows how to use calculation groups to define a default set of values for columns in your model. Different users can have different default values, and yet retain the full capability to select different values. Read more
-
ALLSELECTED is an extremely complex function to use in DAX. In this article, we provide an introduction to ALLSELECTED and its main use cases, leaving the most intricate details to more advanced articles. Read more
-
If you want to execute a DAX query from your code to a Tabular model, you might think that an OLE DB connection should be the right way to get your data. It works, but if you your code is… Read more
-
Several Time Intelligence functions in DAX use a <dates> argument, which has a special behavior because it can be expressed by using both a column reference syntax, a table expression or a Boolean expression. Read more
-
You can create static tables in DAX using the DATATABLE function. This article describes the syntax of this new feature and shows when and how to use it. Read more
-
Translations are a new feature in Analysis Services Tabular 2016. This article explains how to use this feature and introduce SSAS Tabular Translator, a free tool to edit translations files. Read more
-
The RANKX function in Power BI might have an unexpected behavior when applied to a column that has a specific sort order in the data model. This article explains why, and how to address this issue. Read more
-
In budgeting reports, a common requirement is to show future sales forecast and actual sales volume on the same line chart. This article describes how to achieve this goal using DAX. Read more
-
In composite models, any query can be executed on the remote model (wholesale execution) or by mixing local and remote engines together (retail execution). This article describes the differences between the wholesale and retail modes, along with examples. Read more