Forum Discussion
Wrong data connection
Hi everyone I have three tables Table 1 -> Document number and document value Table 2 -> Document number and customer Table 3 -> Customer and customer detail Tables are connected this way: ...
Hi HitcH
Your Power BI is working fine (removing the first row of table 2 and 3 for sure). But the problem is that if you don't have any kind of index column or date to distinguish data, so it will work in the way it is doing.
If you include in your Document Customer the last line, you get this:
| A | aa |
| B | bb |
| C | cc |
| D | dd |
| E | ee |
| F | ff |
| A | aa |
| A | aa |
| C | cc |
| F | ff |
| A | ff |
Anyway, I don't really know what you are trying to achieve
I'm trying to achieve a table that only includes customer detail (big medium and small) and value.
If I add the document inside the table it is working, but in my real data base I have over 3.000 documents, so I cannot read such a huge table, I just need to summarize them by "customer detail" field.
I'd like to only see this (but with the correct values of course):
