topic LOOKUPVALUE Ignore & Include in DAX Commands and Tips

LOOKUPVALUE Ignore & Include

Tob_P — Mon, 28 Nov 2022 09:22:10 GMT

Hi,

I have two tables..

Table 1

No	Delivery
BAR1	1
CAR2	1
DIM3	1
GUM4	0

Table 2

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

Re: LOOKUPVALUE Ignore & Include

Tob_P — Mon, 28 Nov 2022 09:49:18 GMT

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

Re: LOOKUPVALUE Ignore & Include

Anonymous — Tue, 29 Nov 2022 03:15:00 GMT

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