Forum Discussion
Duplicate column values based on value in a different column
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!
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
1 Reply
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