Cumulative total not showing for certain months

[Kolumam]

Hi All,

Why does the cumulative total doesn't show up for the months of November and December. If there's no data for novemeber and december, it should show the same value as that of October. See the below pic which has the formula. Date is just another table. How do I force it to show Dec which also has same value that of October ?

[rajulshah]

Hello @Kolumam,

Please try the following DAX:

Cumulative size = CALCULATE(SUM(Project[Size (Mwp)]), FILTER(ALL('Date'),Date[Date]<=MAX('Date'[Date])))

Let me know if this doesn't work.

Regards.

[Kolumam]

Hi Rajul,

This didn't work as well.

Thanks

Krishna

[Mobashar_Shah]

Hi, 

did you ever get this resolved?

Shah

[v-juanli-msft]

Hi @Kolumam

I can’t reproduce your issue, could you post an example of your dataset? For example, columns of table ‘project’ used here, table ‘date’.

It seems that the cumulative size measure works but not the exact cumulative total, it only calculate values for each row, thus If there's no data for novemeber and december, it shows no bar on the visual.

Best Regards

Maggie