DAX Getting running total from Active orders

Thank you for the references,

I created a query which does what I wanted and I will post it here incase someone has a similar issue.

Running Total MEASURE 1 = 
CALCULATE (
    SUM ( Sheet1[Price x Quantity] ),
    FILTER (
        ALL ( 'Calendar Table' ),
       'Calendar Table'[Date] <= MAX ( 'Calendar Table'[Date] )
    )
) - 
CALCULATE(
    SUM( Sheet1[Price x Quantity]),
    FILTER (
        ALL ( Sheet1 ),
       Sheet1[DateOrderDue] <= MAX ( 'Calendar Table'[Date] )
    )
)

I created a link between my order date in my order book table & calendar table.

I then created a formula to get the cumulative total of all orders added onto the system.

I then created a formulat to subtract the date order due transactions against the calendar date.