Forum Discussion

georgec96's avatar
georgec96
Icon for Helper II rankHelper II
4 years ago
Solved

Nested IF Statement

Hi All, I have a question about an nested if statement and I couldn't find an answer anywhere.   I have the following two columns   Column1 Column2 2 22 blank 9 4 11 blank bla...
  • tamerj1's avatar
    tamerj1
    4 years ago

    Hi georgec96 

    please use

    COALESCE ( TableName[Column1], 

    TableName[Column2] )

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

Hi georgec96 

please use

COALESCE ( TableName[Column1], 

TableName[Column2] )