Forum Discussion

jtkrause14's avatar
jtkrause14
New Member
2 years ago
Solved

Removing Comma after calculated column

I am working with a matrix and created a calcaluted column for a value. The column concatenates all the companies that are in the related to the rows/columns of the matrix with a comma and a line bre...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi jtkrause14 

     

    I’m sorry to hear that you can’t removing Comma after calculated column, I'll give you another way to do it:

     

    Here's some dummy data

     

    Select "Transform data" to enter the power query

     

    Select “customerA” and “customerB”, and select “Group By” in the “Transform”

     

    Select “Sum” and “Fully_Qualified_Name”

     

    Modify the code

     

     

    = Table.Group(#"Changed Type", {"customerA", "customerB"}, {{"CompanyName", each Text.Combine([Fully_Qualified_Name], ","), type nullable text}})

     

     

    Here is the result, and select “Close & Apply”

    View in Desktop

     

    Best Regards,

    Nono Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.