Lookup last delivery date in orders but ignore cancelled ones

[Phil_Waite]

Hi,

I have an expression that looks up the last delivery date from a table of orders. Please see below.

Orders is the other table we are searching.

(MAX ( SELECT(Orders[Delivery Date], [Outlet No] = [_THISROW].[Outlet No]))

How do I get it to ignore orders where the column [Order Status] in table Orders = “Cancelled”

Many thanks

Phil