Forum Discussion
Help Needed: Creating a table from a roling orders hold list
Hi,
I wonder if knowledgeable memebers of the group could help me with this scenario. My apology in advance if I fail to explain it properly.
I have a simple Power Bi report which shows a table of daily orders. The report fetches the data from sql server which is refreshed hourly. The listed orders are blocked due to different reasons, requiring the controller to take action to resolve the issue. A resolved order will disappear from the list after the next refresh but many orders could remain blocked for many days.
| Area | Number | Name | Order# | Quantity | Value | Order Date |
| 11 | 001X11 | Astore | 27700 | 5 | £100.00 | 12/12/2020 |
| 13 | 001X20 | Bstore | 22200 | 8 | £750.00 | 12/12/2020 |
| 15 | 001X70 | Cstore | 19822 | 11 | £800.00 | 15/12/2020 |
| 7 | 001X40 | Astore | 26601 | 2 | £65.00 | 21/12/2020 |
| 20 | 001X01 | Bstore | 90010 | 12 | £950.00 | 21/12/2020 |
A number of orders are booked and released every day. What I want is a table which would record a daily roling count of orders. Something like below.
| Date | Carried | New | Released |
| 12/12/2020 | 30 | 100 | 80 |
| 13/12/2020 | 50 | 25 | 75 |
| 14/12/2020 | 0 | 200 | 110 |
| 15/12/2020 | 90 | 100 | 120 |
Thanks
Ha2san
2 Replies
Hi Anonymous ,
if you want to save values/data, this blog post by Imke Feldmann might help.
Hi mwegener ,
Thank you so much for your response.
My current level of knowledge and licensing probably would not allow me to impliment the solution provided straight away but ceratinly it is something to work on.
