Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 | ||||||
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
41 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
42 | |
33 | |
30 | |
18 | |
18 |