Forum Discussion
LOOKUPVALUE Ignore & Include
Hi,
I have two tables..
Table 1
| No | Delivery |
| BAR1 | 1 |
| CAR2 | 1 |
| DIM3 | 1 |
| GUM4 | 0 |
Table 2
| No |
| BAR1 |
| CAR2 |
| DIM3 |
| GUM4 |
Where in Table 1, Delivery outputs 1, then this is TRUE and O is FALSE, so I want a calculated column whereby if Delivery = 1, and they lookup to Table 2, then I would like to output 'Ignore' and if Delivery = 0, then I would like to output 'Include'.
Can anyone help? There will be values included in both tables that won't necessarily match.
Thanks
Hi Tob_P ,
Here are the steps you can follow：
1. Create calculated column.
Column = IF( 'Table1'[Delivery]=1,TRUE(),FALSE())2. Result:
Is this the result you expected.
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
2 Replies
If it helps, I think I can simplify this by adding a conditional column in Table 1 so that if delivery = 1, then output TRUE
Hi Tob_P ,
Here are the steps you can follow：
1. Create calculated column.
Column = IF( 'Table1'[Delivery]=1,TRUE(),FALSE())2. Result:
Is this the result you expected.
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
