0 votes
1 view
in BI by (10k points)

How can I set cumulative sum for the following dataset

enter image description here

1 Answer

0 votes
by (20.5k points)

Go to measure New measure<- Total <- Running Total and create:

sales running total in part = 
CALCULATE(
    SUM('Query1'[sales]);
    FILTER(
        ALLSELECTED('Query1'[part]);
        ISONORAFTER('Query1'[part]; MAX('Query1'[part]); DESC)
    )
)

which gives us

enter image description here 

Check out the Power BI tutorial for more reference

Get an introduction to Power Bi from the below video: 

Related questions

0 votes
1 answer
asked Jan 4 in BI by Chris (10k points)
0 votes
1 answer
asked Dec 15, 2020 in BI by Chris (10k points)
0 votes
1 answer
Welcome to Intellipaat Community. Get your technical queries answered by top developers !


Categories

...