I want to get a Cumm sum and need to show that data in custom tooltip.

[PSG]

It's for Stacked combo chart. I want to output like if i Hoover my cursor to may month i need my data of APR+MAy to be added and show the result in custom tooltip. Likewise for every month, data needs to be added dynamically. Kindly let me know where I'm gng wrong.

 

 

 

[Dangar332]

hi, @PSG 

if your month is continuse then try below dax measure

var a= max('sheet'1[month])
var b = month(max('sheet'1[month]))-1
var c = calculate(sum('sheet[A]'),'sheet'[month]=a)
var d =calculate(sum('sheet[A]'),'sheet'[month]=b)
return c+d

[PSG]

 Thanks for your reply, but thats not working. Kindly have a look on it. I need cumm sum for each month dynamically.