Forum Discussion
Solved
OPEN ORDERS
Hi, Suppose the sample datas attached. Using this data we would like a measure that tracks open orders so that at each date point on a line chart we are looking at Available qty orders open 30 days...
Thank you for the help.
I use a pattern from SQLBI Computing open orders, and update it from my need.
Sahir_Maharaj
Super User
Super UserHello Voyageur83,
Can you please try this approach:
Open Orders 30 Days Prior =
VAR CurrentDate = MAX('Orders'[DATE_REQUIRED])
VAR PriorDate = DATEADD(CurrentDate, -30, DAY)
RETURN
CALCULATE(
SUMX(
FILTER(
'Orders',
'Orders'[DATE_REQUIRED] <= CurrentDate &&
'Orders'[DATE_REQUIRED] > PriorDate &&
'Orders'[QTY_ORDERED] > 'Orders'[QTY_DELIVERED]
),
'Orders'[QTY_ORDERED] - 'Orders'[QTY_DELIVERED]
)
)