Diference between rows with out all days

[JosePareja]

Hi everybody, first sorry for my english.

I have an excel file upload from PwBI, making a table like this (Colum A, B and C )

In Column C, I have the 3 type of stock per date. In black "15486" I have the stock at closing previus month, so for all days in April, I need to calculate the number in yellow. That is, the 15486 + accumulate value in column E (sum of production per day) less the stock

In meassure DailySales I have the accumulative sales (for ex, 7344 = 15486 + (1550+1650) - 11342) 

So I think, If I make the same meassure "DailySales Previus Day" with PreviusDay(date) function, I can subtract both and that work fine por working days, except non-working days... 

Another Idea was to crear a new table based on this, completing the days in blank and the value must be  the same as the last working day .

I need all your help, I've been stuck many days with this.

[tamerj1]

Hi @JosePareja 

can you provide a sample file?

[JosePareja]

Sorry but No, because it is confidential info of the company. But Ask me what u need to understand

[JosePareja]

This is what im getting