Forum Discussion
Solved
Groupby operation on text data
Hi Experts,
I have the following data
| Shop ID | Date | Attendance | Image link |
| 1 | 2/12/2021 | 1 | img1 |
| 1 | 2/12/2021 | 1 | img2 |
| 1 | 2/12/2021 | 1 | img3 |
I want to convert this data into following foramt
| Shop ID | Date | Attendance | image link 1 | image link 2 | image link3 |
| 1 | 2/12/2021 | 1 | img1 | img2 | img3 |
Kindly suggest the possible way to do this.
Thanks
Hi Minakshi ,
Step1:
Copy and paste table as table2.
Step2:
Remove other columns except image_link column in table2.
Step3:
transpose table2.
Step4:
Merge table1 and table2 as new and remove empty rows.
Pbix as attached.
Best Regards,
Jay
2 Replies
Minakshi , Unpivot the data with Max
https://radacad.com/pivot-and-unpivot-with-power-bi
or in matrix visual use Img link as column and value(max)
Hi Minakshi ,
Step1:
Copy and paste table as table2.
Step2:
Remove other columns except image_link column in table2.
Step3:
transpose table2.
Step4:
Merge table1 and table2 as new and remove empty rows.
Pbix as attached.
Best Regards,
Jay
