Forum Discussion

Dev_B_PBIing's avatar
Dev_B_PBIing
Frequent Visitor
3 years ago
Solved

Show parentheses in table

Hello,

I'm a newer user.  I have a table that contains a concatenated column of Idea names and a unique identifier.  I'm wanting to have the unique identifier show with parentheses and cannot figure it out.  My expression:

 

= Table.AddColumn(#"Changed Type2", "Unique Idea Name", each [Idea name]&" "&[Idea ID]) 

 

In this current setup it returns something similar to Employee Documents 70512345678453 where Employee Documents is the Idea Name and 70512345678453 is the Idea ID.  I want the Idea Id to be in parenthese like so Employee Documents (70512345678453).

 

I'd also like to, if possible, add a bunch of spaces between the two: Employee Documents               (70512345678453)

 

I really appreciate any help!

  • You can try something like...

    Table.AddColumn(#"Changed Type2", "Unique Idea Name", each [Idea name]&"     ("&[Idea ID]&")")

2 Replies

  • You can try something like...

    Table.AddColumn(#"Changed Type2", "Unique Idea Name", each [Idea name]&"     ("&[Idea ID]&")")