Cumulative sum of department

[Saaharjit]

Below is my data table. Is it possible to get a cumulative sum of all units in a SEQ_NO.

For Example - on 01/03/2018 number of units produced in SEQ_NO 101 is 48. The next date is 6 and then 18 and so on. I want the graph to add to show 48 on  01/03/2018 then the next day add 6 and show 54 units (48 + 6 = 54) and then add 18 and so on. Then for the Next SEQ_NO(102) start again.

[Ashish_Mathur · Accepted solution]

Hi @Saaharjit,

You may refer to my solution here.

Hope this helps.

[ccakjcrx]

Hey @Saaharjit!

I created a table in PBI Desktop, and used the following measure to get the outcome I believe you are looking for:

MsrCalSeqNo = 
CALCULATE(
    SUM(Sheet1[Units]),
    FILTER(
        Sheet1,
        Sheet1[SEQ_No]
    )
)

Here is a screenshot of my table visual with that info:

Click HERE to access my .pbix file. 

Hope this helps!