Wanting to use a simple if statement....not working

[jak82]

Hi,

I am wanting to use a simple if statement to set the value of a cell in another table

=IF(adsum[URN]=[URN],"Yay","Nay")

it doesn't seem to recognise the column URN in adsum and only shows up the table.

Thanks

Chris

 

[Special-K99]

Is URN a named range? Don't you have to precede it with an @ sign?

 

[Comfy]

What platform are you using for this? As you have posted in the BI forums, the the structure of your IF statement looks like Excel.

I might be mistaken

For example, In Power Query I would do a join and then use an if to test of the join is null. If null then "Nay" else "Yey"...

 

[jak82]

What platform are you using for this? As you have posted in the BI forums, the the structure of your IF statement looks like Excel.

I might be mistaken

For example, In Power Query I would do a join and then use an if to test of the join is null. If null then "Nay" else "Yey"...

Thanks guys, think I was using the wrong method , sorted now