Forum Discussion

MasterSonic's avatar
MasterSonic
Icon for Helper IV rankHelper IV
4 years ago

cumulative sum or count

Hi guys, I have 2 tables - first with uniqe codes second with dates and category (A,B,C) I have created this :   Count of dates = CALCULATE(     sum('Col1'[code]),     FILTER(         A...
MasterSonic's avatar
MasterSonic
Icon for Helper IV rankHelper IV
4 years ago

Hi amitchadak,

I have added new table 

Date = CALENDAR(DATE(2015,01,01),DATE(2030,12,31))


And applied your code (

instead of sum I have used count tho, column code has also strings within so sum doesn't work) 

 

- it works  but I would like to see smooth rise of overal values
What currenlty I have as a table view are values on the left.
My main goal is to set values like this screenshot from excel in yellow/right.