Pivot Table Text instead of Numbers in Values

[lpw0806]

Hello

Is it possible to get a text instead of a # in the Values section of a pivot table? I have Power Pivot installed because I read that it can help. However I have never used it before and am having a hard time figuring out how to create a pivot table with the data I uploaded (a power pivot)

Thanks
Liz

 

[RoryA]

You can use ConcatenateX to get text in the value fields: https://blog.crossjoin.co.uk/2015/03/19/concatenatex-dax-function-in-excel-2016/

 

[lpw0806]

Thank you so much for the help!

Is that a VBA code? I am trying to understand what a "Measure" is an how to use it

Thanks
Liz

 

[RoryA]

No, it's the Power Pivot equivalent of a Calculated Field in a normal pivot table.