Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
I am currently working with 3 tables which contain same fields in power bi.
I mapped them by using "Append query as new" in power bi (power query).
And then the results are showing doubles even I removed relations, disable load.
Below data is for your reference.
Hi @PPA
It seems you don't have any kind of ID to differentiate, so it's duplicating everything.
Take a look at these to see if they help:
But, can you share some example of your appended tables?
Hi @PPA
Very very difficult to help you without seeing the data. Please supply your file.
Phil
Proud to be a Super User!
| User | Count |
|---|---|
| 3 | |
| 3 | |
| 3 | |
| 2 | |
| 2 |
| User | Count |
|---|---|
| 13 | |
| 9 | |
| 6 | |
| 5 | |
| 5 |