How to remove leading commas from the concatenated String

Hi All,

Leading commas are the result of the BLANK values table values which we are trying to concatenate. For example if I am trying to concatenate values in a table column which contains BLANK, the first value in the concatenated string is blank because of which we dont see the value but just the "," (comma) after that. The solution for this is to filter out blank in the first step.

If I concatenate this Quarters column values, using the formula  

CONCATENATEX( VALUES (Table[Quarters]),Table[Quarters],",") 

It will return ,Q1,Q2,Q3

The easiest way to tackle this is to update the formula to EXCLUDE Blank values

CONCATENATEX( CALCULATETABLE(VALUES (Table[Quarters]),Table[Quarters]<>BLANK()),Table[Quarters],",") 

 This will return Q1,Q2,Q3