Duplicate column values based on value in a different column

[ember17]

I have a dataset (see attached) with tens of thousands of Interaction IDs, many of them matching. I have the following columns: Friendly, Effort, Competent, Trustful, Empowering and Timely, and I would like to duplicate the values in these columns if the Interaction ID is the same. How could I do this in PowerBI Desktop? Thanks for your feedback! 

[djurecicK2 · Accepted solution]

Hi @ember17 ,

 Do you want to duplicate data or have a single row per Interaction ID? For a single row per ID, you could try using SUMMARIZE to get the sum of each column by Interaction ID.

Here is additional information:

https://www.youtube.com/watch?v=IeaPNw_YuQc