Help Needed: Creating a table from a roling orders hold list

[Anonymous]

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

[Anonymous]

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.

[mwegener]

Hi @Anonymous ,

if you want to save values/data, this blog post by Imke Feldmann might help.

https://www.thebiccountant.com/2020/04/13/create-a-load-history-or-stage-in-cds-instead-of-incremental-load-in-power-bi/