Forum Discussion
Solved
Remove Duplicates
Hello, I have a column called "name" and this column duplicates depending on what city they go to. I need to be able to delete the first row of the duplicates and keep the latest actions. I tried th...
Hi,
In the Query Editor, ensure that the column is formatted as Date/Time (since the entries in that column are lft aligned, it seems that the data type of the column is text). Thereafter write this calculated column formula
Test = 1*(Data[created on]=calculate(min(Data[Created on])),filter(Data,Data[Created on]=earlier(Data[Created on])&&data[week number]=earlier(data[week number]))))
Hope this helps.
Is this what you are looking for?
you can do it in power query