Remove rows

[cham]

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 perosn who resposible for that call.

So, I want to delete replaced value and only need to show terminated person details, How can i Do  that?

Please check the below table. I want to remove the highlighted rows.

Date	Caller ID	Destination	Status	Ringing	Talking	Totals	Cost	Reason
1/12/2018	Marry	98728892	answered	0:00:00	0:00:08			Mary replaced by
	Jack	99982725	answered	0:00:00	0:00:17			Mary replaced by Jack
	Peter	92882882	answered	0:00:04	0:01:50			Jack replaced by Peter
	Jude	82272882	answered	0:00:04	0:00:11			Jude was joined
	Rose	82727822	answered	0:00:00	0:03:43	0:06:17	3.9	Terminated by Rose
1/12/2018	Chan	83773883	answered	0:00:04	0:01:50	0:06:17	3.9	Terminated by Chan

[v-juanli-msft]

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

[Anonymous · Accepted solution]

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]

Hi @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

[cham]

Hi Maggie,

Reason column is exist in my dataset.