Forum Discussion
PowerBI_Query
Helper II
Helper IIFilter 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...
PowerBI_QueryHelper II
Helper IIBefore (data is unsorted) highlighted number are repetetive need number in A column with latest date in M column.
After
ronrsnfld
Super User
Super UserI agree with Omid_Motamedise. Either of our proposed solutions will work on that data.