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]
otravers
Community Champion
Community ChampionYou can do so from the Power Query UI as explained here:
https://docs.microsoft.com/en-us/power-query/add-conditional-column
CentaurHi, thank you. I am familiar with at least that much of it but my problem is how do I add a condition as NULL? The value in the table is NULL and I don't see NULL as being one of the operators. Thank you