Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

How to remove leading commas from the concatenated String

Hi Team,   I have a concatenated text string like ",176.22.191.10,None,254.255.244.0" . This is a concantenated value comprises of certain values. Customer doesnt want to see the Leading comma at t...
Need Help
Vvelarde's avatar
Vvelarde
Icon for Community Champion rankCommunity Champion
7 years ago

Anonymous 

 

Hi, try with this:

 

ConcatenatedValues =
CONCATENATEX (
    FILTER ( Table1; Table1[Values] <> BLANK () ),
    Table1[Values],
    ","
)

Regards

 

Victor

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Thanks Victor , 

 

I did tried your suggestion and I see an output like this . I am doing some thing wrong , but I am new to PBI. 

 

Measure : ConcatenatedValues =
CONCATENATEX (
FILTER (Query1,Query1[Target IP Address]<> BLANK () ),
Query1[Target IP Address],
","
)