Dax Help "constant" multiplier

[irnm8dn]

I have a column in my dataset that has the prices of particular items.  I would like to create a calculation that takes this price and multiplies it by 20%, adding the 20% as additional margin to the price of the item.

i.e. 

$1.00 * [Margin) = $1.20

Looking for some quick DAX help on this...

Thanks.

[v-ljerr-msft]

Hi @irnm8dn,

According to your description above, I just assume you have table called "Table1" like below.

Then you should be able to use the formula below to add a calculate column to add the 20% as additional margin to the price of the item. 

Column = Table1[Price] * (1 + 0.2)

Regards

[Anonymous · Accepted solution]

To add to @v-ljerr-msft idea.  Create a measure called "Margin" and assign the 20% value to it.  This would look like

MARGIN = 0.2

Now do what was suggested by creating a column/measure that uses the formula:

NewPrice = 'YourTable'[Price] * (1 + [Margin])