Delete Rows base in different conditions

[nelson777]

Hi there, I have a table where I have the contents of two columns appearing repeatedly on several rows.

I need PowerQuery to scan the table checking and deleting if the conditions are met.

Example: 

When "items.internalId" equals "items.startEpoch"  then deletes the row.

 

after some digging around I tried to use statements such as, "TableSelectRows", "IF" and "Table.RemoveRows" but got just errors as a result.

Thanks,

Nelson

[v-yanjiang-msft]

Hi @nelson777 ,

Has your problem been solved by @Vijay_A_Verma's solution? If yes, please kindly consider accept it as the solution to help the other members find it more quickly.

By my test, it works fine, I also attach my sample below for reference.

If you have other confusion, please feel free to let me know.

Best Regards,
Community Support Team _ kalyj

[Vijay_A_Verma · Accepted solution]

The easiest way would be to insert a custom column and put following formula and then filter on true

= [items.internalId] <> [items.startEpoch]

For one single step, below is Table.SelectRows statement

= Table.SelectRows(Source, each ([items.internalId] <> [items.startEpoch]))