Forum Discussion
IF statement with column from another table
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?
Hi Clout ,
try this:
if [AK_C_P] > #"Global"{0}[GWAblaufPges] then [AK_C_P] else nullIf this post helps, then please consider Accept it as the solution ✔️to help the other members find it more quickly.
4 Replies
- CloutHelper III
Great, that works. Thank you very much!
- prashpawarFrequent Visitor
could you please convert Second table inproper format i.e Unpivot then try your if statement
- CloutHelper III
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