Forum Discussion

Clout's avatar
Clout
Helper III
5 years ago
Solved

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 null

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

     

4 Replies

  • ERD's avatar
    ERD
    Community Champion

    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's avatar
      Clout
      Helper III

      Great, that works. Thank you very much!

  • prashpawar's avatar
    prashpawar
    Frequent Visitor

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

    • Clout's avatar
      Clout
      Helper 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