Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
73 | |
72 | |
39 | |
31 | |
26 |
User | Count |
---|---|
97 | |
87 | |
43 | |
40 | |
35 |