cancel
Showing results for
Search instead for
Did you mean:
Helper V

## Vlookup on 3 columns

Hi,

If a part no.  have Lenth, width height (not blank or zero any of the 3 columns) then YES else NO. I need your help.

 Part no Lenth width Height Result 1233 3 0 5 NO 1234 8 6 NO 1235 2 3 4 YES 1236 2 NO 1237 1 2 3 YES
1 ACCEPTED SOLUTION
Super User II

Hello @sbhan4

Your question is unclear, do you have two tables or do you want the calculation in a single table.

My answer was for a table and I misplaced OR instead of y.

Medida: IF(SELECTEDVALUE(table[Length])>0 && SELECTEDVALUE(table[width])>0 && SELECTEDVALUE(table[Height])>0, "YES","NO")

O

Measurement: IF(ISBLANK(SELECTEDVALUE(table[Length]) ISBLANK(SELECTEDVALUE(table[width]) ISBLANK(SELECTEDVALUE(table[Height]) SELECTEDVALUE(table[Length]) ? 0 ? SELECTEDVALUE(table[width]) to 0 ? SELECTEDVALUE(table[Height]) to 0, "NO","YES")

Hope it resolves your issue?
Please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos, Press the thumbs up button!!👍
Regards,
Pranit
12 REPLIES 12
Super User I

You're looking for an IF statement and not a vlookup..?

If so, create a new column

Result = IF(OR(OR('Table'[Height]=0,ISBLANK('Table'[Height])),or(OR('Table'[Length]=0,ISBLANK('Table'[Length])),OR('Table'[Width]=0,ISBLANK('Table'[Width])))),"NO","YES")
Helper V

@darentengmfs Vlookup or ef else anything is fine. The REsult should come to like that

Super User I

Please try my formula in the reply above.

Super User II

Hi @sbhan4

Please make sure your three number columns are of number type.

Measure = IF(SELECTEDVALUE(table[Length]>0 || SELECTEDVALUE(table[width]>0 || SELECTEDVALUE(table[Height]>0, "YES","NO")

OR

Measure = IF(ISBLANK(SELECTEDVALUE(table[Length]) || ISBLANK(SELECTEDVALUE(table[width]) || ISBLANK(SELECTEDVALUE(table[Height]) || SELECTEDVALUE(table[Length] = 0 || SELECTEDVALUE(table[width] = 0 || SELECTEDVALUE(table[Height] = 0, "NO","YES")

Hope it resolves your issue?
Please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos, Press the thumbs up button!!👍
Regards,
Pranit
Helper V

@pranit828 Hi Pranit,

Well formula should give me YES but giving me "NO". Any suggestions.

Helper V

@pranit828 Thanks. Didn't work for me. Can you provide me pbix file for it?

Super User II

Hello @sbhan4

Your question is unclear, do you have two tables or do you want the calculation in a single table.

My answer was for a table and I misplaced OR instead of y.

Medida: IF(SELECTEDVALUE(table[Length])>0 && SELECTEDVALUE(table[width])>0 && SELECTEDVALUE(table[Height])>0, "YES","NO")

O

Measurement: IF(ISBLANK(SELECTEDVALUE(table[Length]) ISBLANK(SELECTEDVALUE(table[width]) ISBLANK(SELECTEDVALUE(table[Height]) SELECTEDVALUE(table[Length]) ? 0 ? SELECTEDVALUE(table[width]) to 0 ? SELECTEDVALUE(table[Height]) to 0, "NO","YES")

Hope it resolves your issue?
Please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos, Press the thumbs up button!!👍
Regards,
Pranit
Helper V

@pranit828 It worked well. Thank you.

Super User I

Formula given by @pranit828  works perfectly,

@pranit828  you have missed closing Parthese after each Selected value that is creating problem to him

Just Rewrite the Fucntion and Share

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

Proud to be a Super User!

Helper V

@VijayP  Thank you, Vijay! I have provided brackets as well but didn't work for me. Can you please try this out in pbix file.

Super User I

PFA

@pranit828  Did Small Change SELECTEDVALUE not requried

@sbhan4  if you find this as solution please mention this as solution and share your Kudoes

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

Proud to be a Super User!

Super User II

Thank you @VijayP

I have updated the formula.

Hope it resolves your issue?
Please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos, Press the thumbs up button!!👍
Regards,
Pranit

## Helpful resources

Announcements

#### Happy New Year from Power BI

This is a must watch for a message from Power BI!

#### Check it Out!

Click here to read more about the December 2020 Updates!

#### Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

#### Get Ready for Power BI Dev Camp

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

Top Solution Authors
Top Kudoed Authors