Forum Discussion
Blue-Space_34
2 years agoFrequent Visitor
Cumulative sum by year-month
Hello, I have this table that has a year-month column and a count by month. Please, note that the count refers to that particular year-month combination and sometimes you have more rows with the ...
Blue-Space_34
2 years agoFrequent Visitor
Thank you for your reply danextian ,
In this case, I'm not sure if using the dates apply: I have a dates column but dates are not unique in the table, so some dates are repeated.
The only count available is by month and the cumulative must be done aggregating the count month after month.
Therefore is it possible to use the count by year-month in the measure approach instead?
If not, the calculated column approach seems a practical one, I created an index column.
Please, could you please provide more details on how to achieve the cumulative column, cumulative column index and cumulative column (year month) in the second image you provided?
Thanks again in advance for your answer!
danextian
Super User
2 years ago