Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
jtpiazzamn
Helper I
Helper I

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".

 

 

jtpiazzamn_0-1677048772391.png

 

Thank you!

Jim

 

3 REPLIES 3
AllisonKennedy
Super User
Super User

@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?

 


Please @mention me in your reply if you want a response.

Copying DAX from this post? Click here for a hack to quickly replace it with your own table names

Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com

@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.


Please @mention me in your reply if you want a response.

Copying DAX from this post? Click here for a hack to quickly replace it with your own table names

Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.