Forum Discussion
Helper IConverting one Field to Multivalued Field based for each ID
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
asifrasool , refer if these approaches can help
Concatenate Text- Measure, DAX Table, and Power Query Table: https://youtu.be/xAh3tz1qo24
4 Replies
- amitchandak
Super User
asifrasool , refer if these approaches can help
Concatenate Text- Measure, DAX Table, and Power Query Table: https://youtu.be/xAh3tz1qo24
asifrasoolHi 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
- Bubble4502
Resolver III
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.