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.

     

ERD's avatar
ERD
Community Champion
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.

 

Clout's avatar
Clout
Helper III
5 years ago

Great, that works. Thank you very much!