Forum Discussion
Centaur
Helper V
Helper VConditonal 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...
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]
CentaurHelper V
Helper VOtravers,
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
Community Champion
Community ChampionThe 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
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.