Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!
Hello everyone, thank you for the help.
I need to create a custom column in power query editor in advanced editor. I have a column1 with the code of different products (every product have other lines with other valures) and a column2 with a specific characteristic (decimal value). I have to create another column removing the duplicates of the column1 and sum the value of each specific characteristic, like in image below.
Could you help me? Have a easyer way to do this in power bi? I know how to do this in Excel, but i need to do this in Power Bi to avoid data treatment every single time i will use the analysis.
Solved! Go to Solution.
Hi,
Try this : By using group by from power query
The Power BI Data Visualization World Championships is back! It's time to submit your entry.
| User | Count |
|---|---|
| 50 | |
| 43 | |
| 36 | |
| 33 | |
| 30 |
| User | Count |
|---|---|
| 138 | |
| 120 | |
| 60 | |
| 59 | |
| 56 |