cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper I
Helper I

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

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.

1 ACCEPTED SOLUTION
Super User IV
Super User IV

@soubhik 

 

Add the following calculated column to your table:

MinColumn = 

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

 

Fowmy_0-1606805825388.png

________________________

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

 



Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Website   YouTube    LinkedIn

View solution in original post

2 REPLIES 2
Super User IV
Super User IV

@soubhik 

 

Add the following calculated column to your table:

MinColumn = 

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

 

Fowmy_0-1606805825388.png

________________________

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

 



Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Website   YouTube    LinkedIn

View solution in original post

Thank you very much, @Fowmy .

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Wave Release 2

Check out the updates in Power BI.

Overview of Power BI 2020 release wave 2!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors