Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Table transformation

I have a table that looks like this -    ID Financial Code 1 123 2 456 3 789 3 102 2 223 1 413   And, I'd like to transform it into the following table as it enable...
Need Help
Show and Tell
Samarth_18's avatar
Samarth_18
Community Champion
4 years ago

Hi Anonymous ,

 

You can create a measure like below:-

Measure = 
    CONCATENATEX ( VALUES ('Table'[Financial Code] ), [Financial Code], "," )

 

Output:-

 

Thanks,

Samarth