Forum Discussion
REMOVING DUPLICATES AND MERGING QUERIES
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
Super UserPLease share your actual Copy/Pasted M code. The code you shared has syntax errors and non-existing colum names.... So not possible to debug.
The process is an applied steps on power query and those are the code relating to the steps in questions
Due to data privacy issue , unable to share the data/references
Not certain what the syntax error might be also
- adudani
Memorable Member
hi Anonymous ,
I understand data privacy issues.
If you could provide a sample input and output, masking sensitive information in a usable format ( tables, excel, csv, gdrive/ onedrive etc. link to pbix ) , would be happy to support.
for reference:
