Insert Function Dialog Box (SSAS)
The Insert Function dialog box enables you to choose from a list of functions that can be used when building formulas. To access this dialog box from the model designer, in the formula bar above each table, click the function (fx) button. For more information about choosing functions to use in formulas, see DAX Introduction and Build a Formula.
| Item | Description |
| Select a category | If you have a general idea which kind of function you need, choose a category from the list; or select All to view an alphabetical list of functions. |
| Select a function | Displays a list of the functions in the selected category. |
| Description | Displays a description of what the function does, together with any required or optional arguments, such as column names and expressions. |
Function Categories
Data Analysis Expressions (DAX) provides the following types of function categories in the Insert Functions dialog box.
All
Date & Time
Filter
Logical
Math & Trig
Statistical
Text
Measures and Formulas
The Insert Function dialog box is available only when you are building a formula. You can create calculations either in a calculated column, or in a PivotTable or PivotChart. Formulas that you build expressly for use in a PivotTable are also called measures. For more information, see Create a Calculated Column (SSAS Tabular) and Create and Manage Measures (SSAS Tabular).