Create new table by removing duplicates on certain column in current table

Question

Hi All,&nbsp;I already have a current data (Table A) but I want to create a new table by removing the duplicates from the column "Order Number" from Table A. I don't need to transform Table A as I need it as it is, but I need a replica of Table A without the duplicates.&nbsp;Need your help on this.&nbsp;Thanks.

pvo3 · Answer

Then what about a DAX table (data view --&gt; table tools --&gt; new table) then type:
Table = Distinct([Order Number])
Additional columns can be added by logic.

pvo3 · Answer

In Power Query right click the table and press 'Reference'. Right click the [Order number] and press 'Remove duplicates'.

anonymous · Answer

Sorry, but I missed a detail. The table that I have is in Direct Query, so it does not support removing duplicates from the column.

anonymous · Answer

this should be helpful but the result of the query exceeded 1M rows

pvo3 · Answer

I think you should explain in detail what you are trying to achieve with this table. There might be a better solution than to create another table.

Forum Discussion

Create new table by removing duplicates on certain column in current table

6 Replies

Related content

remove duplicate value within a row

Removing Duplicates

Removing duplicates

Remove duplicates bug

M Remove duplicates not working