Running total

[Anonymous]

Hello, I am looking for help in Power BI to accomplish the following. I have a daily shipping target currently of 147 which I would like to be a flexible number to change. I would like the goal to ship out 147 for every WEEKDAY only. If for a specific day we do not hit this target, I want the remaining units to carry over to the following days and so on. I would also like for this to be flexible for the date that we start the cumulative calculations for. 

The data being utilized would have multiple sales orders corresponding to differnent types of products corresponding to dates the orders shipped. Below are a few lines of the data that I would be using

Sales Order	Qty on Shipment	Actual Ship Date	Part Nbr	Shipment Number
S0000030002	10	6/4/2020	z28352	1235412315
S0002003320	1	6/7/2020	f34532	1341324112
S0002003320	4	6/8/020	f34532	1341324152
S0134123412	5	6/9/2020	f23411	1234123414

Below is an example data set that I am able to accomplish in excel, but would like help to display in Power Bi.

Daily Target = 147

Week Day	dates	Daily Shipped	Cumli-Target	cumli-Act	Delta
Sat	5/30	0	0	0	0
Sun	5/31	0	0	0	0
Mon	6/1	33	147	33	-114
Tue	6/2	227	293	260	-33
Wed	6/3	68	440	328	-112
Thur	6/4	112	586	440	-146
Fri	6/5	152	733	592	-141
Sat	6/6	0	733	592	-141
Sun	6/7	0	733	592	-141
Mon	6/8	0	880	592	-288
Tue	6/9	109	1026	701	-325
Wed	6/10	223	1173	924	-249
Thur	6/11	109	1319	1033	-286
Fri	6/12	223	1466	1120	-346
Sat	6/13	109	1466	1120	-346
Sun	6/14	87	1466	1120	-346
Mon	6/15	0	1613	1263	-350
Tue	6/16	0	1759	1431	-328
Wed	6/17	143	1906	1612	-294
Thur	6/18	168	2052	1969	-83
Fri