Forum Discussion

Centaur's avatar
Centaur
Icon for Helper V rankHelper V
4 years ago
Solved

Conditonal Statement

Hello, I am a novice user.  I have 2 fields:  Invoice Amount USD Amount   If USD Amount is Null then I want to show Invoice Amount otherwise, show the USD Amount.  I think this is a conditional...
Tips and Tricks
  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    4 years ago

    Insert a Custom column and paste following (Add column menu - Custom column)

    = [USD Amount]??[Invoice Amount]

    You can also put following formula as an alternative

    = if [USD Amount]=null then [Invoice Amount] else [USD Amount]

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

equals operator followed by "null" (without quotes) as value should do it.

Centaur's avatar
Centaur
Icon for Helper V rankHelper V
4 years ago

Otravers,

I had actually tried prior to posting this question but apparently you cant enter a value of NULL.  It must be a value.  Any other suggestions adding a Conditional Column? 

 

 

  • otravers's avatar
    otravers
    Icon for Community Champion rankCommunity Champion
    4 years ago

    The M language in Power Query is case sensitive, I wrote "null" (not "NULL") for a reason and what I suggested works as demonstrated here:

    • Centaur's avatar
      Centaur
      Icon for Helper V rankHelper V
      4 years ago

      ahh I see now.  Its case sensitive.   I confirm I do not get an error but I do if any letter is capitalized.  Geez that is annoying.