Multiply value if a column value is X, otherwise keep it

[Marcusdahlberg]

Hi

I have a small issue that hope someone here can help me with.

I'm working with a simple excel table that contains sold items and how much discount we have given on each specific produkt.

The items are sold both by unit (1 and 1), but also in boxes/packages (can contain 20 units etc). I have a column that state if it is unit or box (St or Frp). What i would like to do is to make a column that only contain the unit value.

So if the product is sold as a unit (st), then i want to keep the value on how many we sold. But if the sold product is a box, then i want to multiple the amount of boxes with the value from another column that contain the amount of units/box.

Hope you can help me out 🙂

Br Marcus

[Burningsuit]

Hi @Marcusdahlberg 

This is best done in Power Query. In Power BI Desktop, go to "Transform Data" and add a custom column as below...

This will generate a new column "Unit Value" with the calculation you need.

Hope this helps

Stuart