Calculate stock deviation
Here we'll use your knowledge of M Language to check the stock levels of our inventory vs the product average. This can be extremely useful to avoid out-of-stock situations.
More info about creating custom columns can be found in this MSFT Learn article.
If you lost any progress, load the workbook 4_1_stock_deviation.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
