-
Book Overview & Buying
-
Table Of Contents
DAX for Humans
By :
The last chapter was all about dates, one of the core data types within the DAX language. In this chapter we seek to provide similar coverage of another core data type, text. Text is often overlooked in the world of business intelligence, but text plays a pivotal role in both data modeling and user experience. While numbers drive most calculations and visuals, it’s the ability to clean, format, extract, and display text that brings polish and context to a report. This chapter dives deep into the DAX functions that enable text manipulation, starting with fundamental string functions. Through clear examples, we demonstrate how these tools can be combined to perform complex transformation and extraction logic that are crucial in real-world scenarios, such as parsing values from inconsistent formats or building dynamic titles and messages that adapt to filter context.
We also explore more advanced concepts such as how to convert text into tables, count specific character patterns...