Removing rows in Power BI

[Anonymous]

I have a report where two columns represent the time when two different actions started.

I would like to remove the rows of the report that have the same values in these two columns.

The values are depicted in "date, time" format.

[v-jiascu-msft]

Hi @Anonymous,

Power BI has such a function. In Query Editor, select these two columns with "CTRL". Click "Remove Duplicates".

Best Regards!

Dale

[Anonymous]

I have just received an answer in the similar question that I accidentally created. 

http://community.powerbi.com/t5/Desktop/Removing-rows-in-Power-Bi/m-p/243616/highlight/false#M108081

[Anonymous]

Hi Dale,

Thank you for your answer.

My task is a little bit different. Using your first slide, I would have to get rid of 1st and 5th rows as the values in both of the columns are the same ('A' and 'a'). And I would have to keep all the rest rows including 4th and 7st as the values are different (say, 'B' and 'p' in the 2nd row).

Any ideas on that?