Forum Discussion
How to remove a duplicate row having a blank cell?
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
pls see my video
https://1drv.ms/v/s!AiUZ0Ws7G26RiDN2lGwr_jOnp-KB?e=bQykqZSample 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})
Ahmedx
Super User
Super Userpls 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})