Calculate growth for each month

[Anonymous]

Hello!

I would like to calculate the growth over each month,

The dataset is looking like this:

I would like to visualize a graph that shows growth by each month.

For example:

Month	Count of Story	Growth
January	50	50
February	99	149
March	32	181

Thanks in advance!

[amitchandak · Accepted solution]

@Anonymous ,If you have date or create a date like 

Date = "01-" & [Month] & "-" [year] //change datatype to month 

Cumm Sales = CALCULATE(SUM(Table[Count of story]),filter(allselected(Table),Table[Date] <=max(Table[ Date])))

[Anonymous]

Hello @amitchandak!

I have a calendar table with a active relation to my primary dataset.

Do you mean that I should create a Measure called Date aswell? I don't really follow.

Primary Table name: Jira

Calender Table name: Calender

[aj1973]

Hi @Anonymous 

No you don't have to create a new Date table. Use the existing one. just change the name of the table in @amitchandak formula.