Previous chapters have largely focused on the calculation of specific metrics and KPIs that are common to most businesses. This chapter instead focuses on DAX patterns and techniques that can be applied in a variety of different circumstances. While these patterns and techniques are perhaps more uncommon, the recipes provided in this chapter can be critical and instrumental in achieving the desired calculations within DAX.
We will cover the following recipes in this chapter:
- Aggregating multiple columns
- Finding not-in-common/in-common things
- Crafting linear interpolation
- Creating an inverse aggregator
- Finding childless nodes
- Calculating transitive closure
- Computing advanced measure totals
- Using measures where you are not allowed to
- Evaluating permutations and combinations
- Creating a dynamic temporal scale
- Emulating loops
- Simulating recursion