I have 2 columns within power query, one as a helper column that contains numbers in each cell and acts kind of as a back up hwne the next column is empty. The other column contains values and the mentioned empty cells. I wish to perform calculations using these columns and so have formatted these to be as Decimal Number. This causes the empty cells to be returned as null which is fine although I can't get power query to recognise these when creating a custom column. I wish to create an if statement that if the second column is null then the value from the helper column is returned instead.
Testing this in another column using = if [Custom.3] = "null" just returns all values as False so clearly null can't be recognised.
Similarly I am unable to replace error to "" because it has to be a numerical value.
How can I get power query to recognise when a value is not present?
