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.
Kedar_Pande
Super User
Super UserCreate a measure:
Open Orders (30 Days Prior) =
VAR SelectedDate = MAX('DateTable'[Date])
VAR StartDate = SelectedDate - 30
RETURN
SUMX(
FILTER(
Orders, -- Replace 'Orders' with the name of your table
Orders[DATE_REQUIRED] >= StartDate &&
Orders[DATE_REQUIRED] <= SelectedDate
),
Orders[QTY_ORDERED] - Orders[QTY_DELIVERED]
)
Add DateTable[Date] to the X-axis of your line chart.
Use the Open Orders (30 Days Prior) measure as the Y-axis.
💌 If this helped, a Kudos 👍 or Solution mark ✔️ would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn