This chapter contains some of the more mind-bogglingly hard problems to solve in DAX that I have encountered over the years, as well as a few DAX oddities such as creating Scalable Vector Graphics (SVG) graphics and animations. This is not to say that the previous chapters do not have some very hard DAX recipes. This chapter, however, has an abundance of truly complex DAX code that solves some of the more vexing problems you might encounter. Either through brute force or DAX code wizardry, this chapter should put to rest any notion that DAX cannot solve just about any calculation you might throw at it!
The following is the list of recipes that we will cover in this chapter:
- Using dynamic ABC classification
- Creating an inverse slicer
- Unpivoting columns in DAX
- Transposing tables
- Repeating counter with criteria
- Using across then down
- Using matrix multiplication...