Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Filter by last modified on duplicate rows

Hi everyone! I have a question that I'm trying to fix. I imported raw data from my CRM tool and when opening the columns, the Leads' lines were being duplicated as in the example below. The data I...
Need Help
  • ImkeF's avatar
    ImkeF
    5 years ago

    Hi Anonymous ,

    yo have to add a column to your existing table with the following formula:
    Table.Last( [Count] )

     

Anonymous's avatar
Anonymous
Not applicable
5 years ago

When I import the column, it give a List record...

 Maybe that's the "problem"?

  • V-lianl-msft's avatar
    V-lianl-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi Anonymous ,

     

    Please use the ‘Group by’ feature in ‘Edit Query’.

     

     

     

    Best regards,
    Liang