Stock values
After calculating category stock rankings as well as overall stock rankings, it's important for the management team at Northwind to be able to see the dollar-value of their stock levels. So you will use the custom column feature to calculate how much each product's stock is worth.
In addition, your manager has asked you to check if any of the products from the most-stocked category are on backorder (less products in stock + on order than the reorder level).
If you lost any progress, load the workbook 3_2_stock_value.pbix
from the Exercises folder on the Desktop, then open the Power Query editor.
This exercise is part of the course
Data Transformation in Power BI
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
