Converting one Field to Multivalued Field based for each ID

[asifrasool]

Hello Everyone.
I'm currently facing a problem because of that my data is repeating.
My data source is our customer platform from which I'm making API call to get the data. Upon call it automatically expands the columns and there are some values which are coming multiple times for each customers. I want to convert them in order to get them in a row in each cell of corresponding ID.

This is what I'm getting from the system...



How I want them

I hope you would have got the idea. 
Please guide me how to do that...

Thanks

[Bubble4502]

Hi @asifrasool ,

Based on your description, I have created a simple sample:

Please try:

Firrst create a summarized table:

Then add a new column:

Column = CONCATENATEX(FILTER('Table',[ID]=EARLIER('Table 2'[ID])),[Value]," ")

 Final output:

Kind Regards,

Bubble

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

[asifrasool]

Thank you so much @Bubble4502 you solution is awesome. I heartly appreciate your time. 🙂 this is why I love powerbi community. 

[amitchandak · Accepted solution]

@asifrasool , refer if these approaches can help

Concatenate Text- Measure, DAX Table, and Power Query Table: https://youtu.be/xAh3tz1qo24

[asifrasool]

Hi @amitchandak I reply late because I was checking how long this solution will work. It is working awesomely on my 10 different datasets and I have solved the problem. The only thing I had to consider was that I had to create a different table of id and code and then connect that to the main table. But anyway, it really worked amazingly. thank you so much