This article describes the basic structure of analytical expressions in Wyn Enterprise.
When creating analytical expressions, you add a reference to the tables and columns on which you want to perform the calculations. The basic format to add a column reference in an expression is to enclose the table name within single quotes, followed by the name of the column in square brackets. For example,
'FactOnlineSales'[SalesAmount]
Analytical expressions support a varied range of inbuilt functions. These functions can be used for performing complex calculations such as aggregation functions, date and time functions, filter functions, and so on. A function consists of a name and argument(s). The name of the function must be followed by a parenthesis in which the parameters are passed.
SUMX(ALL('FactOnlineSales'), 'FactOnlineSales'[SalesAmount])
Wyn Enterprise supports parameters in WAX expressions. This gives users the flexibility to change the output results based on the parameter values. When creating an expression, click Parameters to add a dashboard parameter.
Note: Only single-valued parameters can be used in WAX expressions.
To include user-related information in the WAX expressions, bind parameters to user-context or organization context values.