Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
60 | |
20 | |
18 | |
18 | |
9 |