DAX HElp

[pmadam]

I need to calculate MIN of 8 columns which has blank values in it. I used below dax but its giving empty value when either of the columns are blank. How to avaoid this 

CY = MIN(MIN(MIN(MIN(MIN(MIN(MIN('Direct Comparison'[DKY_1],'Direct Comparison'[DKY_2]),'Direct Comparison'[DKY_3]),'Direct Comparison'[DKY_4]),'Direct Comparison'[DKY_5]),'Direct Comparison'[DKY_6]),'Direct Comparison'[DKY_7]),'Direct Comparison'[DKY_8])

Please help

[pmadam]

Thankyou. It worked

[TheoC · Accepted solution]

Hi @pmadam 

You should be able to minimise the use of MIN and reduce resource requirements by using a calculated column such as the following:

Min Value = 

VAR _1 = MINX ( { 'Table'[Column1] , 'Table'[Column2] , 'Table'[Column3] , 'Table'[Column4], 'Table'[Column5] } , [Value] )

RETURN

_1

The formula will automatically take into account blanks so there's no need to worry about that.

Hope this helps 🙂

Theo