After merge why the result is get change for column?

[Satish_Kumar]

Hi All,

I just got to know that the result of a certain column is get change when we apply a merge between two table.

Say table 1 is get Merge With table 2 and two and one have some column of calculate value.

And when we again see the total of that column which are now with the same table the value of the column is get changed.

This is thing is happen for no reason if i am missing something please add on my knowledge.

Best Regards,

Satish Kumar

[v-huizhn-msft]

Hi @Satish_Kumar,

You merge the table in Power Query Edit window by clicking MergeQueries operation, and add the second screenshot, right?





Based on your description, I am unable to reproduce your scenario, could you please share a screenshot for further analysis?

Best Regards,
Angelia