Create conditional measure

[AyaneYep]

Dear, I have a table with products and their prices. I want to create a new calculated column that, according to the product, adds +2 to the price.
I want to add 2 if the product is Doll:

Product	Price	New Price
Trolley	5	5
Doll	5	7
Pawn	5	5

I Tried:
measure = IF (Product [Name] = "Doll", Product [Price] + 2, Product [Price]) But it is not working.

[Anonymous]

HI @AyaneYep 

If the measure you mentioned is not working then you have to change your column to whole number type as mentioned below.

[amitchandak]

@AyaneYep , hope creating as new column, not measure

Column= IF (Product [Name] = "Doll", Product [Price] + 2, Product [Price])