Forum Discussion

kfschaefer's avatar
kfschaefer
Helper IV
10 years ago
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...
  • Sean's avatar
    Sean
    10 years ago

    kfschaefer

    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

Rickmaurinus's avatar
Rickmaurinus
Helper V
6 years ago

There's plenty of ways to do it. I like the List.Sum option. But one could also catch the Nulls through conditional-if statements. Or one could also replace null by 0.  Take one that feels comfortable and if the performance is bad, try another. Also check out: 

 

3 Ways to SUM null values in Power Query 

 

Cheers,

Rick

 

--------------------------------------------------

@ me in replies or I'll lose your thread

 

Master Power Query M? -> https://powerquery.how

Read in-depth articles? -> BI Gorilla

Youtube Channel: BI Gorilla

 

If this post helps, then please consider accepting it as the solution to help other members find it more quickly.