cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Kolumam Post Patron
Post Patron

Cumulative total not showing for certain months

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 ?
CUMULATIVE.JPG

4 REPLIES 4
rajulshah Solution Sage
Solution Sage

Re: Cumulative total not showing for certain months

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 Post Patron
Post Patron

Re: Cumulative total not showing for certain months

Hi Rajul,

 

This didn't work as well.

 

Thanks

Krishna

Community Support
Community Support

Re: Cumulative total not showing for certain months

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

Highlighted
Mobashar_Shah
New Member

Re: Cumulative total not showing for certain months

Hi, 

did you ever get this resolved?

 

Shah

 

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Top Solution Authors
Top Kudoed Authors