Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Duplicates returned with Table.Distinct in M Query

Hi, I am trying to create a table containing only distinct rows from the union of two existing Power Query tables in Excel.   My code (anonymised) is: let SelectColumnsT1 = Table.SelectColumn...
Data Modeling
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi v-yulgu-msft,

    Thanks for replying.

    I duplicated this post in "Microsoft Power BI Community / Forums / Get Help with Power BI / Desktop" since I think I created this post in the wrong section.

    Anyway, after a little more work my conclusion was:

     

    <<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.>>

     

    Regards,

    Mark

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi v-yulgu-msft,

Thanks for replying.

I duplicated this post in "Microsoft Power BI Community / Forums / Get Help with Power BI / Desktop" since I think I created this post in the wrong section.

Anyway, after a little more work my conclusion was:

 

<<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.>>

 

Regards,

Mark