Forum Discussion

HamidBee's avatar
HamidBee
Icon for Power Participant rankPower Participant
4 years ago
Solved

Cleaning Data, Fill Down

I'd kindly like to ask how to remove the dates from the this column so that they are blank and then replace the blank cells with the region by filling down. So basically the dates should be replaced ...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi HamidBee ,

     

    Please try the following formula to directly tranform the column instead of adding a new custom column:

      #"Transformed Column"= Table.ReplaceValue(Table.TransformColumns(#"Changed Type",{"Column1",each Text.Remove(_,{"0".."9"})}) ,"//",null,Replacer.ReplaceValue,{"Column1"} ),

     

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

bcdobbs's avatar
bcdobbs
Icon for Community Champion rankCommunity Champion
4 years ago

Have you tried the column from example in power query?

 

Type the region names as they are next to a few regions and delete any attempt to replicate a date. If it looks like it works, inspect the M expression it writes for you.

  • HamidBee's avatar
    HamidBee
    Icon for Power Participant rankPower Participant
    4 years ago

    Could you please explain some of the steps I'm not quite sure what to do here.

     

    Thanks