Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the February 2025 Power BI update to learn about new features.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
84 | |
69 | |
68 | |
39 | |
37 |