How to create a non-zero/non-blank minimum across multiple columns?

[soubhik]

How to create a non-zero/non-blank minimum across multiple columns?

So, the sample data and expected minimum is:

A|B|C|D|E|Min

1|0|4|2|3|1

2|3|5| |1|1

2| |0|5|1|1

I already tried nested MIN() but couldn't figure out how to put a not equals 0 filter in it. It would be great if you could help me out in this.

Thanks,
Soubhik.

[Fowmy · Accepted solution]

@soubhik 

Add the following calculated column to your table:

MinColumn = 

MINX( FILTER({[A],[B],[C],[D],[E]},[Value] > 0 ),[Value] )

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn

[soubhik]

Thank you very much, @Fowmy .