> For the complete documentation index, see [llms.txt](https://docs.powerops.app/powerops/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.powerops.app/powerops/analyze/dax/calculated-columns.md).

# Calculated Columns

In Power BI, calculated columns are used to create new columns in a table by defining a formula that performs a calculation based on existing columns. These calculated columns are then added to the data model and can be used in reports, visuals, and other calculations.

## User Interface

<div align="left"><figure><img src="https://2181169139-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FIZ1QNzp28aI8y60mWhbR%2Fuploads%2Fjjr4nY3YToRNhpwh8vvr%2Fimage.png?alt=media&amp;token=7e99929f-03a9-4dbc-a6ca-f540dc2f195b" alt=""><figcaption></figcaption></figure></div>

The below information about calculated columns are available in Powerops:

1. **Table Name:** \
   Name of table where all calculated columns are stored.
2. **Column Name:** \
   Name given to a column which has been created using DAX formula.
3. **Expression:** \
   Formulas which are written to define the logic to generate values for a new column in a table.
4. **Is Hidden?:** \
   It clarifies if the column is hidden or not.
5. **Is Row Label?** \
   It clarifies if the column is a row label.
6. **Is Key Column?** \
   It clarifies if the column is a key identifier or not.
7. **Display Folder:** \
   Name of the folder which is a container to show group of columns.
8. **Data Type:** \
   The specific category of data (such as text, number, date, etc.) assigned to the values generated by the calculated column's formula.
9. **Synonyms:** \
   It generally refers to alternate names or terms that can be used interchangeably to refer to the same calculated column.
10. **Format:** \
    It refers to specifying the display format for the values generated by the calculated column's formula.
11. **Percentage Format:** \
    It indicates the display format used to present values as percentages.
12. **Thousand Separator:** \
    It refers to the formatting option that adds commas or other symbols to separate thousands in numerical values.
13. **Decimal Places:** \
    It denotes the formatting setting that determines the number of digits to display after the decimal point for numerical values
14. **Sort by column:** \
    The column name based on which column is sorted
15. **Data Category:** \
    Classifies the measure's data type
16. **Summarize By:** \
    Displays the type of aggregation used (if any)
17. **Description:** \
    Refers to a text or comment that provides additional information about the purpose or function of the calculated column.