Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Detect errors by comparing row values in power BI

Hello, I have data like follows:     Here I'm trying to detect rows in which I have errors similar to this one framed in red. In my client file I have  John Doe  with email address : joh...
BA_Pete's avatar
BA_Pete
Icon for Super User rankSuper User
3 years ago

Hi Anonymous ,

 

In Power Query:

Multi-select (Ctrl+click) the [ClientID], [email], and [fullname] columns.

Go to the Home tab > Remove Rows > Remove Duplicates.

Select the [ClientId] column and go to the Home tab > Keep Rows > Keep Duplicates.

 

Pete