Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

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...
Need Help
  • Omid_Motamedise's avatar
    Omid_Motamedise
    1 year ago

    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's avatar
PwerQueryKees
Icon for Super User rankSuper User
1 year ago

Ok. But wouldn't that be a bug in powerquery? Your 2 examples should be equivalent. In both cases S0 should be evaluated first because S1 depends on it...

Omid_Motamedise's avatar
Omid_Motamedise
Icon for Super User rankSuper User
1 year ago

It might be but not in all the case, consider this example
S0=Source,
S1= Table.Addcolumn(S0,"x",....),
S2=Table.Group(S1,"A", {"m",Table.RowCount})


it is true that s2 is calculated based on S1, but its result does not dependent to the result of S1, if you use S0 also in this function, the result would be the same (adding a new column, does not changed the result of counting the rows)