First time working in JOINS and my data is off.
I am trying to get the scores for the locations attached but he scores are way off. I am assuming its a join thing b/c if I take the files individually I get the data I need. Start doing the joins and I am way off. Is there something I am doing wrong to get the bad data?
It appears that you have one to many relationships. If you have measures that need to be aggregated, joining the data will duplicate that record across all the unique values at a lower granularity.
Since the granularity are different, you may be able to accomplish what you are trying to do with data blending (connect to each worksheet individually).