topic Re: DAX HElp in DAX Commands and Tips

DAX HElp

pmadam — Mon, 25 Jul 2022 23:40:11 GMT

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

Re: DAX HElp

TheoC — Tue, 26 Jul 2022 00:26:50 GMT

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

Re: DAX HElp

pmadam — Tue, 26 Jul 2022 00:49:04 GMT

Thankyou. It worked