Create a calculated field

Microsoft Query

Show All

Create a calculated field

You can display the results of a calculation you specify by creating a new field called a calculated field. You can create a calculated field by typing your own expression, which is a calculation that uses a combination of operators, functions, field names, and constants. You can also use a built-in function to calculate totals in a field.

What do you want to do?

Create a calculated field by using an expression

Create a calculated field by using a built-in function