MAX and AND expression

Hi,

I have a main tanle whcihc has a VC that shows the last delivery date for an outlet/row in that main table that is taken from the “Orders” table.

Expression

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

I would also only like to only show orders that have a [Order Total Inc Vat] column in the “Orders” table greatr than 0.

I can’t work out where to ass in the AND() expression.

Thanks

Phil

Please explore the below expression
The below expression assumes that [Order Total Inc Vat] is a Number type column.

MAX ( SELECT(Orders[Delivery Date], AND([Outlet No] = [_THISROW].[Outlet No],[Order Total Inc Vat]>0)))

1 Like

That’s great thank you

1 Like