cancel
Showing results 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")

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

Super User II

Hi @sbhan4

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")

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")

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

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

Proud to be a Super User!

Super User II

Thank you @VijayP

I have updated the formula.

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

Announcements

Happy New Year from Power BI

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