Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I have been working with Power BI for a short time and have a problem where I can't get any further. I want to accumulate lines and output the value per line. Not the gesatmkumulation that I get there. If I have a time structure it is no problem. Only now I have articles without time structure and want to use the values for later calculations e.g. ABC analysis. Does anyone have any advice for me ? The data looks like in the table, that's all I have and I want to calculate the column "Cumulativ Row Value".
Produkt | Value | Rank | Cumulativ Row Value |
f | 20 | 1 | 20 |
g | 17 | 2 | 37 |
b | 12 | 3 | 49 |
c | 11 | 4 | 60 |
a | 10 | 5 | 70 |
e | 7 | 6 | 77 |
d | 6 | 7 | 83 |
I have already tried a lot with SUM, SUMX, CUMULATE... in the form under Internet
Thank you very much!
Solved! Go to Solution.
On a normal field when you right-click in visualization. pane You get an option for running total. Also, you can create a quick measure. Right-click on a table or field under field pane and you will get that option
On a normal field when you right-click in visualization. pane You get an option for running total. Also, you can create a quick measure. Right-click on a table or field under field pane and you will get that option
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
94 | |
83 | |
66 | |
59 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |