Forum Discussion
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 table is showing like this.
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
1 Reply
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