Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
HI,
I have rows that have same Id but data is in two or more rows. I would like to join those rows based on common Id (disregard FID_Namjena). Number of columns is dynamic. How to merge those in PQ?
Solved! Go to Solution.
Sorry, found solution at https://community.powerbi.com/t5/Desktop/Combining-rows-based-on-unique-id-and-combining-information...
Just followed steps, some merge will be needed but this works fine. Thanks
Sorry, found solution at https://community.powerbi.com/t5/Desktop/Combining-rows-based-on-unique-id-and-combining-information...
Just followed steps, some merge will be needed but this works fine. Thanks
| User | Count |
|---|---|
| 45 | |
| 35 | |
| 27 | |
| 17 | |
| 14 |
| User | Count |
|---|---|
| 62 | |
| 57 | |
| 41 | |
| 21 | |
| 20 |