Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Removing duplicates based on Date

I am facing an issue with how i am removing the duplicates from the below set of data in Power Query    What i am trying to do is pick the last price change transaction from a set of data. In the b...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , Create s separate data column

    date only = DateTime.Date([Date])

     

    And the use group by and take max on of the columns that are not needed in group by

amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , Create s separate data column

date only = DateTime.Date([Date])

 

And the use group by and take max on of the columns that are not needed in group by