All or nearly all data models include data in the form of text and numbers. However, it is also often necessary to transform this text and number data into something useful for reporting purposes or even clean up this data for various reasons. This chapter is all about working with text and numeric data, providing useful recipes whose techniques can be applied in a variety of situations.
The following is the list of recipes that we will cover in this chapter:
- Crafting a dynamic slicer title
- Creating a greeting
- Counting a list of items
- Ranking columns and measures
- Totaling measures
- Converting from Cartesian to polar and back
- Computing percentages
- Calculating mode for single and multiple columns
- Extracting text
- Detecting prime numbers