The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hi!
People, I need to do a column accumulating values. But I have a problem. I have this structure:
On the image:
COLUMN 1 - RANK (FAILLING)
COLUMN 2 - PRODUCT CODE
COLUMN 3 - VALUE I WANT TO ACCUMULATE
COLUMN 4 - (IT'S THE ABC CURVE CLASS. I NEED THE ACCUMULATED COLUMN TO GET IT RIGHT)
COLUMN 5 - ACCUMULATED
My rank isnot working as well. Because my codes can have equals values. Then, when I go to accumulate, the SUM stop on values until it's not repeating.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Proud to be a Super User!
Awesome Keyboard Shortcusts in Power BI, thumbs up if you like the article
My Community Blog Articles (check them out!)
My Blog - Power M code to automatically detect column types -
How to create test data using DAX!
User | Count |
---|---|
28 | |
10 | |
8 | |
6 | |
5 |
User | Count |
---|---|
33 | |
13 | |
12 | |
9 | |
7 |