MAX and AND expression

[Phil_Waite]

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

[Suvrutt_Gurjar · Accepted solution]

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

[Phil_Waite]

That’s great thank you