OPEN ORDERS

Hello 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]
        )
    )

hi 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

voyageur

Create 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