Forum Discussion

dtango9's avatar
dtango9
Helper II
2 years ago
Solved

Repeating Values in Data Table

Hello, I'm experincing an issue with one of my data tables.  It is repeating values/creating duplicates, when only 1 transaction should be showing.  Can someone help me please?  I don't know why the ...
Need Help
  • TomMartens's avatar
    TomMartens
    2 years ago

    Hey dtango9 ,

    it seems this is happening in Power Query, at least the column header looks like this.

    Repeating values often indicate insufficient joins of tables. Maybe this article helps to understand what I'm talking about: https://gorilla.bi/power-query/join-types/

     

    Of course, if you are not joining tables, then you have to check your data source and get in touch with the owners of the data source.

     

    Hopefully, this helps to tackle your challenge.

     

    Regards,

    Tom

TomMartens's avatar
TomMartens
Super User
2 years ago

Hey dtango9 ,

it seems this is happening in Power Query, at least the column header looks like this.

Repeating values often indicate insufficient joins of tables. Maybe this article helps to understand what I'm talking about: https://gorilla.bi/power-query/join-types/

 

Of course, if you are not joining tables, then you have to check your data source and get in touch with the owners of the data source.

 

Hopefully, this helps to tackle your challenge.

 

Regards,

Tom