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]

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

Note:  I am using Power Query not Power BI.   

Vijay_A_Verma's avatar
Vijay_A_Verma
Icon for Most Valuable Professional rankMost Valuable Professional
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]

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

    Adding a Custom Column worked.   I note that if I add a Conditional Column the word null must be lower case.    

     

    here is what I used:

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

     

    I discovered its CASE SENSITIVE, which is annoying.  

     

    thank you very much for the help.