Dax to calculate where a column value is within another columns value

[ajaydavidluke]

Hi Community,

Below is a simple table containeing Numeric values, I'm trying to create a dax which goes like:

If 'Main Box Est' <= 'WA Box Qty' (taken from a related table) then 'Main Box Est' else 'WA Box Qty'

Casn anyone suggest a simple solution?

Many thanks in advance!

[ajaydavidluke · Accepted solution]

Thanks people but the solution arrived to my mind after pressing post!

Box est =

IF(

'Replenishment Main Box hayley'[Main Box Est] <= 'Replenishment Main Box hayley'[WA Box Qty],

'Replenishment Main Box hayley'[Main Box Est],

'Replenishment Main Box hayley'[WA Box Qty])