Wyn Enterprise User Guide

Syntax

This article describes the basic structure of analytical expressions in Wyn Enterprise.

Basic Syntax for Analytical Expressions

Add Tables and Columns Reference

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]

Define Functions

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])

Specify Parameters

Following is the list of parameters supported in the analytical expressions in Wyn Enterprise.

Parameter Description
expression Any analytical expression that returns a single (scalar) value. The expression is evaluated multiple times for each row or context.
value Any analytical expression that returns a single (scalar) value. The expression is evaluated exactly once before all the other operations.
table Any analytical expression that returns the data of the table. It could be a table or a table manipulation function.
tableName Returns the name of the table. It cannot be an expression.
columnName Returns the name of the column. It cannot be an expression.
name A string constant that provides the name of the new object.
order An enumeration that determines the sort order.