Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
114 | |
98 | |
96 | |
68 | |
67 |