cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
pmadam
Helper I
Helper I

DAX 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(MIN(MIN('Direct Comparison'[DKY_1],'Direct Comparison'[DKY_2]),'Direct Comparison'[DKY_3]),'Direct Comparison'[DKY_4]),'Direct Comparison'[DKY_5]),'Direct Comparison'[DKY_6]),'Direct Comparison'[DKY_7]),'Direct Comparison'[DKY_8])
 
pmadam_0-1658792377193.png

 

 

Please help

1 ACCEPTED SOLUTION
TheoC
Community Champion
Community Champion

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

_1

The formula will automatically take into account blanks so there's no need to worry about that.

TheoC_1-1658795181158.png

Hope this helps 🙂

 

Theo

 

If I have posted a response that resolves your question, please accept it as a solution to formally close the post.

Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!

Want to connect?www.linkedin.com/in/theoconias

View solution in original post

2 REPLIES 2
pmadam
Helper I
Helper I

Thankyou. It worked

TheoC
Community Champion
Community Champion

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

_1

The formula will automatically take into account blanks so there's no need to worry about that.

TheoC_1-1658795181158.png

Hope this helps 🙂

 

Theo

 

If I have posted a response that resolves your question, please accept it as a solution to formally close the post.

Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!

Want to connect?www.linkedin.com/in/theoconias

Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

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

Top Solution Authors
Top Kudoed Authors