I have two queries in Power Query that I need to join together.  I have created a key so each state has its own number.  When I merge my Crop Report Query with my Harvested Query some states doubled up with different data coming from somewhere? My code below was filtered down to a single state that is showing the problem.

​I have two queries in Power Query that I need to join together.  I have created a key so each state has its own number.  When I merge my Crop Report Query with my Harvested Query some states doubled up with different data coming from somewhere? My code below was filtered down to a single state that is showing the problem.         Read More

​