How to remove a duplicate row having a blank cell?

[ahooee]

Hi

I am trying to remove rows only if "Tcode" is a duplicate and "Transaction text" is blank. May I know how to do that?

Thanks

Reza

[ahooee]

Great, many thanks Ahmedx 🙂

[Ahmedx · Accepted solution]

pls see my video
https://1drv.ms/v/s!AiUZ0Ws7G26RiDN2lGwr_jOnp-KB?e=bQykqZ

Sample PBIX file attached
https://1drv.ms/u/s!AiUZ0Ws7G26RiDJ5iB9RA3lgQcnR?e=wcEbBQ

= Table.TransformColumns(
#"Grouped Rows",{"Count",(x)=> if Table.RowCount(x)> 1 then  Table.SelectRows(x,
(y)=> y[Data] <>"") else x})