cumulative count is getting blank when data is not available for the date

[avulasandeep]

HI EVERY ONE

i have one question for you why the  cumulative count is getting blank when data is not available for the date.   it suppose to show last cumulative count instead of blank.

  i am posting here  pic  that i am getting 0 for the data is not available for the cumulative count  for the  full days, it has to display last cumulative count right for the unavailable of data .  

Here it has to show the 14 for remaining dates.

if any one knows about this  please reply .

Thanks 

sandeep 

[v-yuezhe-msft · Accepted solution]

@avulasandeep,

Do you have a calendar table? Create relationship between calendar table and your original table using date field, then create cumulative count measure using Date field of calendar table, and drag date field  of calendar table to X-Axis of the chart.

This way, you should get 14 for remaining dates.

Regards,
Lydia

[nannimora]

i have a problem quite similar to you.

this is my post

https://community.powerbi.com/t5/Desktop/Sum-Sales-Group-by-date/td-p/428363

i hope we can find a solution