Chapter 10Text Functions
This chapter deals with text (or string) manipulation. Most of the text functions are the same as their Excel function equivalents; however, they accept text or column parameters rather than worksheet cells or ranges. Many of these text functions return text, and as such are usually more suitable for creating calculated columns in PowerPivot tables rather than measures—text values can’t be added together to give subtotals and totals in a pivot table (unless you do a COUNT()). Having said that, if the text value can be converted into a number (for example the string “123”), then it may be used as an additive measure. Usually, PowerPivot will implicitly do the conversion, but you can always do it explicitly with the VALUE() ...
Get Practical PowerPivot & DAX Formulas for Excel 2010 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
