Chris Webb
blog.crossjoin.co.uk
Chris Webb is a member of the Power BI Customer Advisory Team at Microsoft.
SQLBits 2011
Fun with Scoped Assignments in MDX
This session will introduce the concept of scoped assignments in MDX and show how they can be used to solve various calculation problems.
Scoped assignments are one of the most powerful features in MDX, but also one of the most difficult to understand. This session will introduce the concept of scoped assignments, how they can be created and what kinds of calculations can be implemented using them. Some previous knowledge of MDX will be assumed.