Forum Discussion

gvg's avatar
gvg
Post Prodigy
4 years ago
Solved

We cannot convert the value null to type Number

Hi, I know there is a number of threads with this title, however none of them provide clear answer. At least for my case. I am getting this message when trying to sort a column with integer values....
Need Help
  • mussaenda's avatar
    mussaenda
    4 years ago

    Hi gvg,

     

    as per my experience on this error, I am replacing error with text then filter the column with the replaced value.

    So I can check why this value is giving error and adjust the applied steps.

     

    Hope this helps.

mussaenda's avatar
mussaenda
Community Champion
4 years ago

Hi gvg,

 

as per my experience on this error, I am replacing error with text then filter the column with the replaced value.

So I can check why this value is giving error and adjust the applied steps.

 

Hope this helps.

  • gvg's avatar
    gvg
    Post Prodigy
    4 years ago

    mussaenda ,

    tried that. I even get error after I try to get all values loaded in the filter box after I replace errors with some text value:

     

    Strangely enough Power Query displays null in the filter box, but still complains that it can not convert null to type Number.

    • mussaenda's avatar
      mussaenda
      Community Champion
      4 years ago

      If there is no any confidential data, you can DM me the file to check. 

      Else,

       

      The is a value that Power query cannot convert to the data type you chose which shows error.

      • gvg's avatar
        gvg
        Post Prodigy
        4 years ago

        Well, I managed to figure out what was the problem by deleting records until I saw the error. It looks like PQ does not replace all kinds of errors. Errors that were not captured by "Replace Errors" were those that arose as a result of merging tables. 

        Anyway, thank you for the tip.