How to fill empty rows with non-existent values?

Question

OLAP

There is a table that contains several hundred thousand records of quantity changes (the fact of the change = the date of the entry in the table). The third field is the change to the date

. How can I fill in the data for all the numbers, using the data from the date for which they are? To get it like this:

SQL2014/2016 is used
UPD: I thought that such a thing can be implemented within the framework of OLAP analytics, where the cube itself will complete the virtual dates. But how to transfer at least the existing data there and force the cube to build aggregates?

Answer 1

stupidly, but simply: we fill the table with all the necessary dates (a kind of grid) and with it the original one through full outer join