0
$\begingroup$

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

2,3,5,Blank,1

I want 1, not Blank.

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

1 Answer 1

0
$\begingroup$

Try this as a DAX Column (not measure):

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

Power BI

$\endgroup$

Your Answer

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

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