Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
I am trying to remove the duplicate "INC_NUM" and only the latest date (Submit) should remain alongwith its summary.
How do i do it.
Solved! Go to Solution.
@gigotomo
Here is one way to do this
Please refer the below thread to achieve your need.
https://community.powerbi.com/t5/Desktop/Drop-duplicate-rows-retaining-latest-date/m-p/878537
Hi All,
I know this has already been answered, but it looks like Pragmatic Works has a more simple soloution to the problem involving "Table.Buffer".
https://www.google.com/search?q=power+query+how+to+sort+by+newest+date+then+remove+older+duplicates&...
This worked for me also!
This was the most helpful for me.
Please refer the below thread to achieve your need.
https://community.powerbi.com/t5/Desktop/Drop-duplicate-rows-retaining-latest-date/m-p/878537
Super !!!
@gigotomo
Here is one way to do this
Thanks for the post
Took me a while to get my head around it, but it once I got it, it is actually real simple and effective.
I found it helpful to convert the dates to numbers. My other challenge was that I had two date columns. A start date but a termination date that was blank so I had to create a new custom column and give the blank date todays date in order to merge the start and termination date to get the biggest value to group by.
Cheers
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
88 | |
86 | |
82 | |
68 | |
49 |
User | Count |
---|---|
138 | |
111 | |
104 | |
65 | |
64 |