# Insert Function Dialog Box (SSAS)

**SQL Server 2016**

Applies To: SQL Server 2016

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. |

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

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