Forum Discussion
cham
Post Patron
Post PatronRemove 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...
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
Community Support
Community SupportHi cham
Does the last column "Reason" exsit in your dataset?
or is it written by you here to illustrate the case?
If the last column "Reason" doesn't exsit in your dataset, how do i find which rows need to be deleted?
Best Regards
Maggie
chamPost Patron
Post PatronHi Maggie,
Reason column is exist in my dataset.