DAX Parameter Naming Conventions

DAX has standard parameter names to faciptate the usage and understanding of the DAX functions. Further, you can use certain prefixes to the parameter names. If the prefix is clear enough, you can use the prefix itself as the parameter name.

To understand the syntax of the DAX functions and to use data values appropriately for the relevant DAX function parameters, you need to understand DAX parameter naming conventions.

Parameter Names

Following are the DAX standard parameter names −

Prefixing Parameter Names or Using the Prefix Only

You can quapfy a parameter name with a prefix −

The prefix should be descriptive of how the argument is used.

The prefix should be in such a way that ambiguous reading of the parameter is avoided.

For example,

Result_ColumnName − Refers to an existing column used to get the result values in the DAX LOOKUPVALUE () function.

Search_ColumnName − Refers to an existing column used to search for a value in the DAX LOOKUPVALUE () function.

You can omit the parameter name and use only the prefix, if the prefix is clear enough to describe the parameter. Omitting the parameter name and using only prefix can sometimes help in avoiding the clutter during reading.

For example, Consider DATE (Year_value, Month_value, Day_value). You can omit the parameter name – value, that is repeated thrice and write it as DATE (Year, Month, Day). As seen, by using only the prefixes, the function is more readable. However, sometimes the parameter name and the prefix have to be present for clarity.

For example, Consider Year_columnName. The parameter name is ColumnName and the prefix is Year. Both are required to make the user understand that the parameter requires a reference to an existing column of years.