4
Text
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 ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access