Forum Discussion

cham's avatar
cham
Post Patron
7 years ago
Solved

Remove rows

Hi,   I'm having data set includes call details. Some calls are replace by other users. So one call can be replace by many users. But i want to get the terminated user details because he is the per...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    7 years ago

    Add a conditional column to filter out the "replaced" value rows with blanks. Then, remove the blank rows.

     

     

    Then in modelling tab, simply filter the blank rows or generate the following Power query code:

     

    = Table.SelectRows(#"Changed Type", each [Custom] <> Blank())

     

    Please accept the solution if I answered your query.

v-juanli-msft's avatar
v-juanli-msft
Community Support
7 years ago

Hi cham 

Does sbelanix 's suggestion really help you?

If it does, could you kindly accept it as a solution so others may benefit from it.

If not, please let me know.

 

Best Regards

Maggie