Stopping a cumulative sum at the last data point

[jthomson]

Hi,

Sample data looks something like this:

StartPeriod	CancellationTiming
A	1
A	1
A	2
A	3
A
A	6
A
A
A	10
A
B	1
B	1
B	1
B	3
B	7
B
B
B
B
B
C	1
C	2
C	2
C	4
C	5
C
C
C
C
C

What I need to do is create a count of the number of entries in the CancellationTiming column and plot them against an x-axis running from 1-12, with the y-axis indicating the count of rows which have a timing less than or equal to each relevant x-axis point and (this is what I'm having trouble with) have the line stop at the last point at which there is an entry. So something like this is the desired end product:

I have the x-axis on a separate table (just a list of numbers from 1-12), and the DAX measure I'm using is this:

CumulativeCancellations = 

var stoppoint = max([CancellationTiming])

var nullpoint = if(stoppoint = max(MonthTable[MonthNumber]), blank(), 2)

return min (nullpoint, calculate(countrows(MainTable), MainTable[CancellationTiming]<>blank(), MainTable[CancellationTiming]<=max(MonthTable[MonthNumber])))

However that just runs the line all the way from 1-12 and ignores the attempted logic telling it to stop. What am I doing wrong?

[Anonymous]

Hi @jthomson ,

Seems a bit strange, what field is MonthTable[MonthNumber] in the formula you provided?

Best Regards,
Adamk Kong

[jthomson]

It's an unconnected table containing the numbers 1-12.