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.
FreemanZ
Super User
Super Userhi Voyageur83 ,
try like:
measure =
VAR _date = MAX(data[date_required])
VAR _result =
SUMX( FILTER(
data,
data[ date_required]>= _date- 30
&&data[ date_required] <= _date
),
QTY_ORDERED - QTY_DELIVERED
)
RETURN _result