Month on Month cumulative count for each level

[AlwaysAGooner]

Hi all,

Need help in calculating the month on month cumulative count for Level achieves by individuals.

Current data doesn't have the sum of Jan & Feb for Feb, and so on.

Required data - Feb is Jan + Feb. March is Jan + Feb + Mar, so on.

Pls help

[AlwaysAGooner]

@xifeng_L 
Any suggestions???

[xifeng_L · Accepted solution]

There are no numeric columns that need to be aggregated, so it's a count of level? If so, you can try the following measure.

Measure = CALCULATE(COUNT('Table'[Value]),'Table'[Date]<=MAX('Table'[Date]))

[AlwaysAGooner]

I can make it work with Date coming from my Date Table instead, Thanks

[xifeng_L]

Hi @AlwaysAGooner ,

You can refer to below demo.

Did I answer your question? If yes, pls mark my post as a solution and appreciate your Kudos !

Thank you~

[AlwaysAGooner]

My Data is like below, Pls suggest

Thanks

[xifeng_L]

It's the same, just change the names of the columns used in the formula.

If the formula doesn't turn out as expected, you can post a screenshot of the error result.

[AlwaysAGooner]

How will SUM function work on Textual Data (Level 1, Level 2, Level 3)?

[xifeng_L]

Aren't you aggregating the values of the individual Levels?, the text of Level1, Level2, etc. are just used as row labels.

Am I misunderstanding this?

[AlwaysAGooner]

No. Do not have that aggregation in my table