topic Month on Month cumulative count for each level in DAX Commands and Tips

Month on Month cumulative count for each level

AlwaysAGooner — Thu, 30 May 2024 14:10:10 GMT

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

Re: Month on Month cumulative count for each level

xifeng_L — Thu, 30 May 2024 15:40:08 GMT

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~

Re: Month on Month cumulative count for each level

AlwaysAGooner — Fri, 31 May 2024 07:01:01 GMT

My Data is like below, Pls suggest

Thanks

Re: Month on Month cumulative count for each level

xifeng_L — Fri, 31 May 2024 07:20:57 GMT

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.

Re: Month on Month cumulative count for each level

AlwaysAGooner — Fri, 31 May 2024 07:45:21 GMT

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

Re: Month on Month cumulative count for each level

xifeng_L — Fri, 31 May 2024 07:57:49 GMT

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?

Re: Month on Month cumulative count for each level

AlwaysAGooner — Fri, 31 May 2024 08:02:08 GMT

No. Do not have that aggregation in my table

Re: Month on Month cumulative count for each level

AlwaysAGooner — Mon, 03 Jun 2024 06:44:01 GMT

xifeng_L
Any suggestions???

Re: Month on Month cumulative count for each level

xifeng_L — Mon, 03 Jun 2024 14:05:54 GMT

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]))

Re: Month on Month cumulative count for each level

AlwaysAGooner — Mon, 03 Jun 2024 14:23:25 GMT

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