Forum Discussion
Solved
Calculate column handling Null values
Need to add 2 columns together, however one of the columns may contain a Null value and if Null the return the original value. what is the proper syntax? I need to add the Revenue columns and al...
select the column => Transform tab => Replace Values => Value To Find: null Replace With: 0
You may have do this step "Replaced Value" before the "Added Custom" where you add the 2 columns
select the column => Transform tab => Replace Values => Value To Find: null Replace With: 0
You may have do this step "Replaced Value" before the "Added Custom" where you add the 2 columns
Wherever possible I avoid changing data.
Try this instead:
each List.Sum({[ColA], - [ColB], [ColC]})
to perform ColA - ColB + ColC
My full line being:
= Table.AddColumn(#"Previous Step Name", "Sum", each List.Sum({[ColA], - [ColB], [ColC]}), Int64.Type)
