Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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

Hi All,   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 nee...
General Comment
Need Help
Show and Tell
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
3 years ago

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.

PVO3's avatar
PVO3
Icon for Impactful Individual rankImpactful Individual
3 years ago

Then what about a DAX table (data view --> table tools --> new table) then type:

Table = Distinct([Order Number])

Additional columns can be added by logic.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

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

    • PVO3's avatar
      PVO3
      Icon for Impactful Individual rankImpactful Individual
      3 years ago

      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.

      • PVO3's avatar
        PVO3
        Icon for Impactful Individual rankImpactful Individual
        3 years ago

        Alternatively you might use table.group