Null values causing error on Custom Column

[GuilleATT]

Hi,

I have an Amount column that also have some null's.

I'm using this expression to create a new column:

= Table.AddColumn(#"Expanded Table", "Selected", each if [Amount USD] < 50000 and [Company] = "A" then "Yes" else if [Amount USD] is null and [Company] = "A" then "Yes" else "No")

The resulting column is giving me errors whenever there was a null of the Amount USD Column.

Appreciate your help,

Guillermo

[Pragati11 · Accepted solution]

Hi @GuilleATT ,

Clean up your NULL values in Power BI to 0 by replacing them. As your column is a AMOUNT column - you should clean it and have only numeric values in it.

Once you replace these NULLS wit Zeroes, modify your formula against NULL condition.

It will not give error.

Thanks,

Pragati