Need help with getting cumulative total

[Anonymous]

Hi all,

The table i am working with only the first four columns. How do I go about filtering the table by "Department", "Team", "Quarter" and getting the cumulative total in a new column as shown below.

Department-----	Team-----	Quarter-----	Items sold-----	Cumulative total of items sold
Department A	Team 1	Q1	30	30
Department A	Team 1	Q2	22	52
Department A	Team 1	Q3	10	62
Department A	Team 1	Q4	13	75
Department A	Team 2	Q1	10	10
Department A	Team 2	Q2	12	22
Department A	Team 2	Q3	6	28
Department A	Team 2	Q4	2	30
Department B	Team 3	Q1	1	1
Department B	Team 3	Q2	3	4

Thank you,

chq

[amitchandak]

@Anonymous , if you need a new column

sumx(filter( Table, [department] = earlier([department]) && [Team] = earlier([Team])  && [Quarter] <= earlier([Quarter]) ), [item Sold] )

Power BI DAX- Earlier, I should have known Earlier: https://youtu.be/CVW6YwvHHi8
https://www.youtube.com/watch?v=cN8AO3_vmlY&t=17820s

or you can measure using new window function

Power BI Window function Rolling, Cumulative/Running Total, WTD, MTD, QTD, YTD, FYTD: https://youtu.be/nxc_IWl-tTc