Create measure/Column with incremental sum

[Anonymous]

Hello ,

I've senerio like below.

PART   PRIORITY        ORD_DATE             BO_QTY     
P1             28        5/4/2020 0:00                 30                  
P1             29        4/17/2020 0:00              10                   
P1             29        4/17/2020 0:00              20                  
P1             29        5/12/2020 0:00              70                  
P1             29       5/12/2020 0:00              110                                                                                                                                        Output measure should be like below , Which sould be having the cumulative sum of QTY

DATE,PRIORITY and PART all are duplicated, So we can not consider any key for addition.

PART   PRIORITY        ORD_DATE             BO_QTY     Output Measure/Column
P1             28        5/4/2020 0:00                 30                   0
P1             29        4/17/2020 0:00              10                   30
P1             29        4/17/2020 0:00              20                   40
P1             29        5/12/2020 0:00              70                   60
P1             29       5/12/2020 0:00              110                 130   

Kindly let me know the how the "Output Measure/Column" has to be calculated on the baseic of the QTY Cumulative sum

[v-zhenbw-msft · Accepted solution]

Hi @Anonymous ,

We can create an index column and a calculate column to meet your requirement.

1. In Power Query Editor, we can add an index column using index column function.

2. Then we can create a calculate column to get the result.

Output = 
var x = CALCULATE(SUM('Table'[BO_QTY]),FILTER('Table','Table'[Index]<EARLIER('Table'[Index])))
return 
IF(ISBLANK(x),0,x)

If it doesn’t meet your requirement, could you please show the exact expected result based on the table that you have shared?

BTW, pbix as attached.       

Best regards,

Community Support Team _ zhenbw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.