Forum Discussion
Add the values in one column based on another column.
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.
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/339586
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])
2 Replies
- Greg_Deckler
Community Champion
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/339586
- amitchandak
Super User
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])