Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 |
Solved! Go to Solution.
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? Did I answer your question? Mark my post as a solution! Appreciate your Kudos, Press the thumbs up button!! Linkedin Profile |
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |