Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to Solution.
Hi @Saaharjit,
You may refer to my solution here.
Hope this helps.
Hi @Saaharjit,
You may refer to my solution here.
Hope this helps.
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!
User | Count |
---|---|
99 | |
90 | |
85 | |
74 | |
67 |
User | Count |
---|---|
114 | |
103 | |
100 | |
72 | |
64 |