Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

How do i replace all incoming null values? My data source is a sharepoint list

In sharepoint list, the user has to pick yes or leave it empty which will add an entry as "flase" My data contain answer for a while ago so all old values are "null". All the recent answers are either "true" or "false". How do i replace all the null values? And I am not 100% sure that there wont be any more null values in the future.

 

Also I'm new to power bi. Please keep your answer noob friendly

 

Need Help
Tutorial Requests
  • Fowmy's avatar
    Fowmy
    4 years ago

    Anonymous 

    In Power Query,  Right-Click a null value and choose Replace Value then click OK. This replaces any null in that column when you refresh the data.

     

4 Replies

  • Fowmy's avatar
    Fowmy
    Super User
    4 years ago

    Anonymous 

    In Power Query,  Right-Click a null value and choose Replace Value then click OK. This replaces any null in that column when you refresh the data.

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      I'm currently using this but what if there are more null values in the future? also there are a lot of null values and i replace all of them everytime.

       

      • Fowmy's avatar
        Fowmy
        Super User
        4 years ago

        Anonymous 

        No worries', it will be replaced in the future as well when you refresh your data.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Anonymous ,

     

    Does the replies above solve your problem? If it has been solved, please mark the correct reply as the standard answer to help the other members find it more quickly.Thank you very much for your kind cooperation!

     

    Hope it helps,


    Community Support Team _ Caitlyn

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