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})
2 Replies
- Ahmedx
Super User
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})