> For the complete documentation index, see [llms.txt](https://docs.fabricplan.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.fabricplan.com/planning-sheets/how-tos/infobridge/data-transformations/add-column.md).
# Add Column
## Add columns in Infobridge
Use transformation commands on the **Transform** ribbon to create calculated measures, dimensions, split columns, and conditional columns. These transformations enrich bridge data without modifying the source report and cascade to downstream reports.
### Open transformation commands
After creating a bridge, open the **Transform** tab to access data transformation options.
The Transform ribbon provides these commands:
* Add Measure
* Add Dimension
* Split Column
* Conditional Column
### Add a measure
Use **Add Measure** to create calculated measures with expressions and built-in functions.
The following example creates a measure named **Gross Profit Margin (%)** that calculates profit as a percentage of sales.
1. On the **Transform** ribbon, select **Add Measure**.
2. Enter **Gross Profit Margin (%)** as the measure name.
3. Select **Formula**.
4. Enter the following expression:
```
("Sum of Profit" / "Sum of Sales") * 100
```
5. Select **Apply**.
The new measure appears in the bridge and is available for reporting and other transformations.
### Add a dimension
Use **Add Dimension** to create new dimensions with expressions and conditional logic.
The following example creates a **Profit Rating** dimension that categorizes records based on profit values.
1. On the **Transform** ribbon, select **Add Dimension**.
2. Enter **Profit Rating** as the dimension name.
3. Create a CASE expression that evaluates profit ranges and returns a category.
4. Select **Apply**.
Example logic:
```sql
CASE
WHEN "Sum of Profit" < 1000 THEN 'Decommission'
WHEN "Sum of Profit" > 1000 AND "Sum of Profit" < 5000 THEN 'Break even'
WHEN "Sum of Profit" > 5000 AND "Sum of Profit" < 10000 THEN 'Average Sales'
WHEN "Sum of Profit" > 10000 THEN 'Target achieved'
ELSE 'N/A'
END
```
The new dimension appears in the bridge.
### Split a column
Use **Split Column** to divide a dimension into multiple dimensions with a delimiter or character position.
The following example splits the comma-separated values in the **Market & Geography** column into separate columns.
1. On the **Transform** ribbon, select **Split Column**.
2. Select **Market & Geography** as the target column.
3. Select **By delimiter** as the split type.
4. Enter a comma (`,`) as the delimiter.
5. Select **Apply**.
The transformation creates separate columns for each value segment.
### Add a conditional column
Use **Conditional Column** to create values based on business rules and conditions.
For example, a conditional column can categorize records into risk levels, regions, business segments, or other classifications.
#### Example: Categorize debt-to-equity ratios
The following example categorizes debt-to-equity ratios into risk levels.
| Debt-to-Equity Ratio | Risk Level |
| -------------------- | ------------- |
| 2.5 | Moderate Risk |
| 1.8 | Low Risk |
| 3.0 | High Risk |
#### Example: Assign tax and shipping rates
The following example assigns tax rates and shipping rates based on region.
| Region | Tax Rate | Shipping Rate ($) |
| ------------- | -------- | ----------------- |
| North America | 20% | 50 |
| Europe | 15% | 70 |
| Asia | 12% | 60 |
| Africa | 8% | 40 |
#### Create a conditional column
Use conditional logic to create a **Global Market** column based on country values.
| Country | Global Market |
| ------------------------ | ------------- |
| Canada | NAMER |
| France | EMEA |
| Germany | EMEA |
| Mexico | LATAM |
| United States of America | DOMESTIC |
1. On the **Transform** ribbon, select **Conditional Column**.
2. Enter **Global Market** as the column name.
3. Configure the required conditions and output values.
4. Optionally define a default value in the **Else** section.
5. Select **Apply**.
The new conditional column appears in the bridge.
---
# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.
## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.
Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:
```
GET https://docs.fabricplan.com/planning-sheets/how-tos/infobridge/data-transformations/add-column.md?ask=&goal=
```
`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.
Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
