Thank you for your response.
I tried, I think it help me but unfortunate it's not working for me. I am giving specific value as "0" where its NULL and selected all options one by one by. its not displaying in report (crosstab). can you please guide if I am missing any things.
Very hard to say without a twbx. There are actually 3 threads all very similar floating about, all wanting to know how to populate data that doesn't exist and none have included a packaged workbook. Subsequently they all remain unanswered...therefore please post a twbx so someone is able to look at what you're also looking at and try to fix this for you.
I found out a way to do this and calculated data till current date with left outer join to calendar table (data base calendar table) and finally populated data till current date and then displayed in tableau.
All are happy
Hope this will help.