Forum Discussion
combining multiple rows into 1
I'm importing a JSON file. When I expand the data, its taking a field (Dev_Exp) which allows the user to select mulitple boxes, and Its putting the response into seperate rows (ie: Front end, Back end, UI/UX). The key field is UserID is causing errors as you can't have more than 1 key. Is there a way I can combine the multiple rows, which in this case I need to combine the Dev_Exp column into 1.
So the result would have Dev_Exp for this user (ID 11) to be "Front end, Back end, UI/UX".
Thank you!
Jim
3 Replies
jtpiazzamn , very similar to this question I just answered: Concatenate unique values from multiple columns - Microsoft Power BI Community
Use the ConcatenateX function if you don't mind this being a measure. Otherwise you could try using Group By functionality, but depends what you want as the end result?
AllisonKennedy Thank you for your response. I'd like to combine them and not use a measure. This doesn't affect all users, just some. I'd like to combine the values to show back in the 1 field. As a work around, I did export the API feed to an excel file, which puts all values from the field to 1 cell, and imported that. It sounds like I may have to go back to the dev team and see if there is a way for the data to be saved. . I will try the "group by" function.
jtpiazzamn How did you get on with the Group By function?
Also, why do you need it as a column and not a measure? That may help guide what further advice or workarounds we can suggest.
