Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Duplicates returned with Table.Distinct in M Query

Posted this by mistake in the Ideas section.  Reposting here.   Hi, I am trying to create a table containing only distinct rows from the union of two existing Power Query tables in Excel.   My c...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    7 years ago

    Hi,

    This works

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Ashish.

Your code is more or less the same as mine.

I have experimented on using an up to date version of Excel (my office uses Excel 2013, my personal laptop has the latest Excel 365).

The problem disappears on my version of Excel, so I think maybe I've uncovered a bug in the old version, which I guess I can't get around.

Thanks for spending the time to help me out.

Regards,

Mark

Ashish_Mathur's avatar
Ashish_Mathur
Super User
7 years ago

You are welcome.