Right Pad Text record values with spaces

wfarm Perhaps a Custom Format String. Otherwise, you could do this:

Measure = 

  VAR __Text = MAX('Table'[Column])

  VAR __Len = LEN(__Text)

  VAR __Rept = 25 - __Len

RETURN

  REPT(" ",__Rept) & __Text

Or perhaps I am not understanding.

Thanks Greg.

My situation is that I want to build a matrix with this field becoming the column. The number of values will change from monmth-to month. I can set the column width now and turn off "Auto-fit" on the column settings but then next month I may get a value in a record that is longer and then it stretched out and doesn;t automatically wrap. I was hoping that if I set a maximum length and then kept auto-wrap on, the new values, along woth the previously seen values, would all be the same width.
Am I missing something?
Is there another way to deal with this so that my column widths remain constant?

THanks!