Cumulative calculation issue

[cthurston]

Hello the issue I am having is that the actuals measure is not showing $0 values.  I'm quite certain that the value provided is blank.  I would like to format it to 0 instead so that the line visual is continuous.

[v-jiascu-msft]

Hi @cthurston,

Please try to replace the "Blank()" with 0 in the formula. 0 and "Blank()" are different. 

Best Regards,

Dale

[cthurston]

Sorry Dale I should have clarified, I have tried replacing the blanks with zeros, and since its a measure it provides s0 for months I dot not want to show.

[v-jiascu-msft]

Hi @cthurston,

I would suggest you add another IF statement that will hide the months you don't want to show and show months you want. Can you share a dummy sample?

Best Regards,

Dale

[v-jiascu-msft]

Hi @cthurston,

Did you solve it?

Best Regards,

Dale