Forum Discussion
Removing Comma after calculated column
- Anonymous2 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.
jtkrause14 try this
CompanyNames =
CALCULATE (
CONCATENATEX (
VALUES('Customer'[Fully_Qualified_Name]),
'Customer'[Fully_Qualified_Name] &
IF (
'Customer'[Fully_Qualified_Name] <> LASTNONBLANK('Customer'[Fully_Qualified_Name], 1),
", " & UNICHAR(10),
""
),
""
)
)