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 |
|---|---|
| 59 | |
| 46 | |
| 31 | |
| 17 | |
| 16 |
| User | Count |
|---|---|
| 79 | |
| 68 | |
| 43 | |
| 26 | |
| 23 |