IF statement with column from another table

[Clout]

Hello guys,

I have two tables:

Table "Frachten"

Date / AK_C_P

1.1 / 1

2.1 / 2

3.1 / 3

Table "Global"

GWAblaufPges

2

So this first table contains of two columns with multiple rows and the second table of multiple columns but with only one row with a value.

I now want to create a custom column in my table "Frachten" to check if [AK_C_P] is bigger than [GWAblaufPges] and take over this value, when its not bigger, the column should have the value null

I tried out this IF statemant but it doesn't work:

IF [AK_C_P] > Table.SelectColumns(Global, GWAblaufPges) then [AK_C_P] else null

Can anyone help me to create a working statement?

[ERD · Accepted solution]

Hi @Clout ,

try this: 

if [AK_C_P] > #"Global"{0}[GWAblaufPges] then [AK_C_P] else null

If this post helps, then please consider Accept it as the solution ✔️to help the other members find it more quickly.

[Clout]

Great, that works. Thank you very much!

[prashpawar]

could you please convert Second table inproper format i.e Unpivot then try your if statement 

[Clout]

So you mean to unpivot the table "Global"?

Now the structure is like this:

Attribute            /  Value

GWAblaufPges /   2

But the if statement still doesn't work