none
How to delete duplicate records and keep the latest record. RRS feed

  • Question

  • Hi power query masters,

    I'm working on power query and stuck at this problem.

    I have a Table with 2 columns:

    Record ID  -  Update Date

    1                    5/1

    1                    5/2

    2                    5/1

    2                    5/2

    I want to only keep one record for each Record Id, with the latest Update Date.

    Result would be:

    Record ID  - Update Date

    1                    5/2

    2                    5/2

    Appreciate any help on this.

    Wednesday, May 23, 2018 5:11 PM

Answers

All replies