Forum Discussion
combining multiple rows into 1
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.
