Comparing values in 3 tables with the same structure (contains pbix)

[OKgo]

I would really appreacite some help or pointers what to google as to why Mean Table 1 displays OK but the other two are not displaying correctly

Pbix file: https://bit.ly/2H8MYOv

[Ashish_Mathur]

Hi,

That link does not work.

[OKgo]

Sorry about that

https://www.dropbox.com/s/ayzvdqa7i9ri4nv/Multiple%20Tables.pbix?dl=0

[Ashish_Mathur · Accepted solution]

Hi,

You need to append data from all 3 Tables.  Go to Home > Edit Queries.  On that screen, go to Home > Append Queries as New.  Build you visual from this appended Table.

Hope this helps.

[OKgo]

Hi Ashish. I had treid that method and failed. What I was doing wrong is that each "mean" column had the same name. If I give each mean column a slighty differnt name before the append.queries as new - it works great. Thank you so much 🙂

[Ashish_Mathur]

You are welcome.