O'Reilly logo

Practical PowerPivot & Dax Formulas For Excel® 2010 by Art Tennick

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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() ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required