Get startedGet started for free

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

View Course

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise