Forum Discussion

PowerBI_Query's avatar
PowerBI_Query
Icon for Helper II rankHelper II
2 years ago

Filter duplicate rows with latest date

I have a data table as shown in the sample file   Sheet1 (before)  I need the output as shown in Sheet2 (after) The data is not sorted. I need to exclude duplicate rows using latest date as criteri...
Show and Tell
Tips and Tricks
Omid_Motamedise's avatar
Omid_Motamedise
Icon for Super User rankSuper User
2 years ago

The link doesn't work for me if you could provide a screen of your data, that would be great but based on the general description, you can easily add a column and provide the number reputation of each row and the napply filter, or you can use table.group as mentioned in the above

  • PowerBI_Query's avatar
    PowerBI_Query
    Icon for Helper II rankHelper II
    2 years ago

    Before (data is unsorted) highlighted number are repetetive need number in A column with latest date in M column. 

    After

     

     

    • ronrsnfld's avatar
      ronrsnfld
      Icon for Super User rankSuper User
      2 years ago

      I agree with Omid_Motamedise. Either of our proposed solutions will work on that data.