topic Dax to calculate where a column value is within another columns value in DAX Commands and Tips

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

ajaydavidluke — Fri, 12 Aug 2022 11:36:03 GMT

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 — Fri, 12 Aug 2022 11:48:35 GMT

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