Forum Discussion
REMOVING DUPLICATES AND MERGING QUERIES
Hi All, I am hoping i could get some help, I have two set of queries on Power Query and for query 1 ( I have duplicates data due to entries on different date), i have sorted the date in desc...
on the steps, after sorting data, a new step will added into your query steps which its formula starts with Table.Sort(....), befor removing the duplicteas, revise this formula by addin Table.Buffer befor it and rewrite the formula as
Table.Buffer(Table.Sort(....))then remove duplicat. your peoblem become solved
PwerQueryKees
Super User
Super UserSorry, can't help you then...