I have a table with 5 columns. I want to have a 6th column that gives the minimum from the first 5 line by line but some the 5 columns have blank entries so my min column picks these up as the minimum. How can I get the minimum I want? For example

If my numbers are


I want 1, not Blank.

  • $\begingroup$ I'm triyng to found the second min. Do you know how to do it ? $\endgroup$ Jul 19 at 14:57

1 Answer 1


Try this as a DAX Column (not measure):

Min = 
VAR temp = { 'Data'[Column1], 'Data'[Column2], 'Data'[Column3], 'Data'[Column4], 'Data'[Column5] }
    MINX ( Temp, [Value] )

Power BI


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.