Forum Discussion

jessicarocha's avatar
jessicarocha
Icon for Helper IV rankHelper IV
4 years ago
Solved

Replace empty text values by most frequent value based in another column

Hi everyone,    there are master data problem with my dataset. I need to make a flow map and several customers have empty city location. However, there is the country available.  Would it be possi...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    jessicarocha , In power query, fill down in an easy option , if that can work. The top city needs a summarized table then the top record filter and then merge and create a new column

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

jessicarocha , In power query, fill down in an easy option , if that can work. The top city needs a summarized table then the top record filter and then merge and create a new column

jessicarocha's avatar
jessicarocha
Icon for Helper IV rankHelper IV
4 years ago

Hi amitchandak , 

 

thanks for the help. The fill down option don't really work for me, but I will use your suggestion and create another table with the given cities. Then, I'll merge it. Thanks a lot!