Add the values in one column based on another column.

[Harshwardhan]

I want to add the values in the C1 column according to their respective StockItemNames and put those values in another column C2. I attaching some photos which show an example of I want the final output. Please help me with this DAX.

[Greg_Deckler · Accepted solution]

@Harshwardhan  - You will need to have something in your data that defines "previous". See my article on Mean Time Between Failure (MTBF) which uses EARLIER: http://community.powerbi.com/t5/Community-Blog/Mean-Time-Between-Failure-MTBF-and-Power-BI/ba-p/3395...

[amitchandak · Accepted solution]

@Harshwardhan , to get C2, you need an index or some date column

https://stackoverflow.com/questions/45715963/creating-an-index-column-for-power-bi

Try a new column

sumx(filter(Table, [stockitemname] = earlier([stockitemname]) && [index] <= earlier([index])),[C1])

[Greg_Deckler · Accepted solution]

@Harshwardhan  - You will need to have something in your data that defines "previous". See my article on Mean Time Between Failure (MTBF) which uses EARLIER: http://community.powerbi.com/t5/Community-Blog/Mean-Time-Between-Failure-MTBF-and-Power-BI/ba-p/3395...