Forum Discussion

moatazbelah's avatar
moatazbelah
Regular Visitor
4 years ago
Solved

Remove Values in column

Can I remove the highlit values based on Column A (Name)? For example, in the picture below, I'm trying to remove the values in column C 200,000, and 52,221. which is the last name on the list of com...
Need Help
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    4 years ago

    Hi, moatazbelah ;

    You could replace this values in power query ro null.such as:

    The final output is shown below:

    Or add a custom column then delete origin column.


    Best Regards,
    Community Support Team _ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

v-yalanwu-msft's avatar
v-yalanwu-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi, moatazbelah ;

You could replace this values in power query ro null.such as:

The final output is shown below:

Or add a custom column then delete origin column.


Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.