Remove Duplicate and let one of them stay

[Anonymous]

Hi guys,

I have a column like this: 

Messages

Hi there

What up

What up

My Name is John

What Up

Cool Story

I want: 

Messages

Hi there

What Up

My Name is John

Cool Story

So I want to delete the duplicates in one column (not row) and let one of them stay. Is this possible?

Thank you guys.

[amitchandak · Accepted solution]

@Anonymous , You can display this column in visual that will show only unique value.

Select this column in power query, right click and remove duplicate that will remove the rows for duplicate value for this column

Or create a new table in DAX

distinct(Table[COlumn])