Calculate Cumulative demand column based on Part NO and Date (oldest to newest)

[ikarouscb]

Hello Awsome comunity 

is there anyone that can help me to calculate this Power BI column based on the following information

0.- the column "**bleep** Demand" shows the real reesults that need to be obtain from the dax formula, (it appears on the image due to i manually calulated it on Excel, but needs to be calculated via DAX on power BI)

1.- the PKGREQ colum is the one that should be added

2.- the addition must happen on dates order from oldest to newest

3.- the **bleep** cuantity should restart everytime the part number changes, or take the latest cumulative value of the same part number from the previous date

it should be performed on a Colum due to the right colums calculate using the "**bleep** Demand" as base for independant calculation

Example 1 - One Part Number

Example 2 - Two part numbers

[Anonymous · Accepted solution]

Hi @ikarouscb ,

1. Add an index column after sorting the date column in ascending order in the power query editor.

2. Create a calculated column in power bi desktop.

Column 2 =
CALCULATE(SUM('Table'[pkgreq]),FILTER(ALL('Table'),'Table'[partno] = EARLIER('Table'[partno]) && 'Table'[Index] <= EARLIER('Table'[Index ])))

If your Current Period does not refer to this, please clarify in a follow-up reply.

Best Regards,

Clara Gong

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

[ikarouscb · Accepted solution]

Hello Clara!! thank you very much for the help this was so helpfull for my development!! i really apreciate the support!! now the file is working great!!

[Anonymous · Accepted solution]

Hi @ikarouscb ,

1. Add an index column after sorting the date column in ascending order in the power query editor.

2. Create a calculated column in power bi desktop.

Column 2 =
CALCULATE(SUM('Table'[pkgreq]),FILTER(ALL('Table'),'Table'[partno] = EARLIER('Table'[partno]) && 'Table'[Index] <= EARLIER('Table'[Index ])))

If your Current Period does not refer to this, please clarify in a follow-up reply.

Best Regards,

Clara Gong

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