Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Measure to concanate a column with string

Hello,   I have a column (with categories)  Example AAA BBB CCC DDD EEE And i would like to create a measure that adds a string after each line. E.g. "in %", like a sufix A...
bcdobbs's avatar
bcdobbs
Icon for Community Champion rankCommunity Champion
4 years ago

Hi,

I think you want a calculated column rather than a measure.

 

Following DAX will do what you need:

 

New Column = Table[Original Column] & " in %"

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    I have a limited dataset, I canť see data or add any additional columns into tables. Only measures is possible to create. 

     

    So I´m curious if this works for any measures?