Forum Discussion

Shelley's avatar
Shelley
Post Prodigy
5 years ago
Solved

How to Replace Negative Values in Power Query with 0

Hi All, This is probably easy, but I can't seem to figure it out. I have some columns in the query editor that I would like to replace all the negative values with 0. I tried this, and it looks like ...
Need Help
  • CNENFRNL's avatar
    CNENFRNL
    5 years ago

    Shelley , if you're looking to replace negative numbers in some certain column, you might want to try

    = Table.TransformColumns(#"Changed Type4", {{"Base List Price (ZP00)", each List.Max({_, 0})}})
CNENFRNL's avatar
CNENFRNL
Community Champion
5 years ago

Shelley , if you're looking to replace negative numbers in some certain column, you might want to try

= Table.TransformColumns(#"Changed Type4", {{"Base List Price (ZP00)", each List.Max({_, 0})}})
osama_ayoub's avatar
osama_ayoub
Helper III
3 years ago

CNENFRNL 

can I use this function but not only in one columns but in all my table columns in a dynamic way without mention all the column names of the table ?
thanks in advance