Formula to Add 10% to a Value in Another Column

Formula in DAX (Data Analysis Expressions)

To add 10% to a value from another column in Power BI or a related context, the following DAX formula can be used:

New_Value = [Original_Value] * 1.1

Explanation of the Formula

• New_Value: This is the name of the new calculated column or measure where the modified value will be stored.
• [Original_Value]: This is the reference to the existing column that contains the original values to which you want to apply the 10% increase.
• 1.1: This factor represents the increase of 10%. Multiplying by 1.1 effectively adds 10% of the original value because:
  • 100% (original value) + 10% (additional value) = 110% of the original value.

Logic

1. Reference the Original Column: The formula directly references the column that contains the base values.
2. Calculate the Increased Value: The multiplication by 1.1 computes the new value, integrating the original value and the desired percentage increase in a single step.

Practical Example

Consider the following dataset in a Power BI environment:

You want to create a new calculated column that will reflect prices with a 10% increase.

Implementation

1. Open your Power BI desktop.
2. Navigate to the Data view.
3. Select the table containing the Original_Price.
4. Click on "New Column" and enter the following DAX formula:

New_Price = [Original_Price] * 1.1

Resulting Table

After applying the formula, the table will look like this:

Conclusion

This formula effectively allows users to create a new column that reflects the original values increased by 10%. This approach is particularly useful in scenarios such as pricing adjustments, forecasting, or general data manipulation where percentage increases are common.

For further learning and practical applications of DAX, consider exploring the courses available on the Enterprise DNA Platform.