power bi remove duplicates based on date

I Just have some doubts 1) Why did you use the MAXX function between the Date But when you do this in Power Query, it does not work as expected. Or it would be easier to suggest a solution. You want to remove those duplicates and only keep unique values. 2. I would like to delete the duplicate rows based on the lower FTE after first summing the FTE. Using Group By on the client number and removing any that are = 1 . Then, create a custom column. How about saving the world? Connect and share knowledge within a single location that is structured and easy to search. Copyright Windows Report 2023. ); Re: Remove duplicates based off of max date value https://community.powerbi.com/t5/Community-Blog/Winner-Topper-on-Map-How-to-Color-States-on-a-Map-wi https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601, Microsoft Power BI Learning Resources, 2023, Learn Power BI - Full Course with Dec-2022, with Window, Index, Offset, 100+ Topics, Formatted Profit and Loss Statement with empty lines, https://wicren-my.sharepoint.com/:u:/g/personal/michael_wicren_onmicrosoft_com/ETfpMdkq_uFGt63Ensazfj4BmRyzgtNDoy1n8nGl9jxi-A?e=BaMAnP, https://community.powerbi.com/t5/Desktop/Remove-duplicates-based-on-values/td-p/59148, How to Get Your Question Answered Quickly. =let mydate = [PDR complete date] in Table.SelectRows ( [All Rows],each [PDR complete date] = mydate) Then, expand the columns you need and delete the All Rows column. I have then isolated the duplicates with different dates, to leave a table of just the client number and date logged on. https://community.powerbi.com/t5/Desktop/Drop-duplicate-rows-retaining-latest-date/m-p/878537. Removing duplicates is a critical step when cleaning your data in Power Query. Remove duplicates based off of max date value from another column. You have four rows that are duplicates. I tried now to group by client and identify the duration between the log-ons. "+String(e)+r);return new Intl.NumberFormat('en-US').format(Math.round(569086*a+n))}var rng=document.querySelector("#restoro-downloads");rng.innerHTML=gennr();rng.removeAttribute("id");var restoroDownloadLink=document.querySelector("#restoro-download-link"),restoroDownloadArrow=document.querySelector(".restoro-download-arrow"),restoroCloseArrow=document.querySelector("#close-restoro-download-arrow");if(window.navigator.vendor=="Google Inc."){restoroDownloadLink.addEventListener("click",function(){setTimeout(function(){restoroDownloadArrow.style.display="flex"},500),restoroCloseArrow.addEventListener("click",function(){restoroDownloadArrow.style.display="none"})});}. To remove duplicates case-insensitive, you can make use of the optional equation argument of Table.Distinct. @Jimmy801could you please further explain the AddDuration step, as I used this previously to remove the duplicates on the same day. Power Query will remove all duplicates from the selected column.