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 row...
Need Help
  • ERD's avatar
    ERD
    5 years ago

    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.

     

prashpawar's avatar
prashpawar
Frequent Visitor
5 years ago

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

Clout's avatar
Clout
Helper III
5 years ago

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