Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register 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
| User | Count |
|---|---|
| 50 | |
| 35 | |
| 29 | |
| 17 | |
| 17 |
| User | Count |
|---|---|
| 66 | |
| 57 | |
| 39 | |
| 22 | |
| 21 |