Happy 2015! Hope you all have a wonderful, fun-filled and AX-filled New Year!

We will kick off the new year with mention of a new Five Good Minutes by my colleague Chad Carnes – which I always enjoy seeing.

The official description:

“In this episode of Five Good Minutes Chad Carnes highlights the Inventory Value Report in Microsoft Dynamics AX. He show how any functional user can combine an AX Report with Power Pivot reporting to create simple answers to complex reporting problems.”

My summary:

Chad simply and easily shows you how you can run an ordinary AX report, leverage built-in functionality to save an AX report to Excel (including both running it to show on your screen and alternately to a location), and “slice and dice” to show the results you want – for example, groupings, subtotals.

But the really cool extension Chad shows here is that you can easily use Power Pivot here to effectively create drill down functionality for high level reports.

Everyone reading this can imagine the possibilities…

Click the image below to go to the blog post with the video.

Go view, have fun, and as always, Happy DAXing!