Forum Discussion
pmadam
Helper II
Helper IIDAX HElp
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(...
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
_1The formula will automatically take into account blanks so there's no need to worry about that.
Hope this helps 🙂
Theo
pmadamHelper II
Helper IIThankyou. It worked