{"id":1662,"date":"2026-11-17T16:24:00","date_gmt":"2026-11-17T14:24:00","guid":{"rendered":"https:\/\/www.kaarne.fi\/superstore\/?p=1662"},"modified":"2026-11-17T16:24:07","modified_gmt":"2026-11-17T14:24:07","slug":"power-query-join-row-count","status":"publish","type":"post","link":"https:\/\/www.kaarne.fi\/superstore\/articles\/power-query-join-row-count\/","title":{"rendered":"The Rows Multiplied After the Join. Did the Business Really Grow?"},"content":{"rendered":"<p>You combine the sales file with a lookup table. The report now contains more rows, and the total is larger. Before celebrating growth, find out what one row in the combined result actually represents.<\/p>\n<p>A join connects matching records. If the relationship is different from the one you expected, expanding those matches can change the number of rows in a way that needs explanation.<\/p>\n<h2>Define the expected relationship<\/h2>\n<p>Consider a fictional small wholesaler. Its transaction file contains order lines, while a product lookup should describe each product once. The coordinator expects each line to find one product description.<\/p>\n<p>If the lookup contains several records for a product code, a line can match more than one record. That may be a data issue, or the lookup may legitimately describe versions or locations. The reporting decision depends on the intended relationship.<\/p>\n<p>Microsoft\u2019s Power Query guidance explains that a merge joins tables using selected matching columns. Choose those columns and the join type deliberately. Do not treat a familiar-looking dialog as evidence that the business relationship is correct.<\/p>\n<h2>Count at the useful checkpoints<\/h2>\n<p>Record the starting row count, the expected matches and the count after expansion. Also compare a relevant amount where appropriate. Explain any intended increase, such as an order being represented by its separate lines.<\/p>\n<p>A row-count increase is a signal to investigate, not automatic proof of an error. Conversely, an unchanged count does not prove that every match is right. Check several recognisable records and any unmatched cases.<\/p>\n<p>Keep order identity separate from line identity. Otherwise an attempt to remove \u201cduplicates\u201d may discard legitimate detail that the report needs.<\/p>\n<h2>Investigate the matching keys<\/h2>\n<p>Inspect the lookup for repeated keys and the source for missing or inconsistent identifiers. Agree whether a code should be unique within the relevant scope. If a date, location or version is part of that scope, include the appropriate business rule in the plan.<\/p>\n<p>Do not delete repeated records merely to make the total return to its previous value. First establish which records are valid and how the report should represent them.<\/p>\n<p>Where a match remains uncertain, keep it on a review list. That preserves the question for the person who can resolve it instead of hiding it inside a convenient filter.<\/p>\n<h2>Build a tiny join exercise<\/h2>\n<p>Create fictional source rows for one unique match, one missing match and one key with two lookup records. Write the expected result before running the merge and expansion in a test copy.<\/p>\n<p>Compare actual records with that expectation. Can you explain every row that appears? Does the total reflect the intended business unit? Record the decision so a colleague can follow it next month.<\/p>\n<p>The useful result is a combined table whose structure you understand. A larger number deserves a business explanation only after you have ruled out a change in how the data was combined.<\/p>\n<h2>Keep the reporting method connected<\/h2>\n<p>Explore the <a href=\"https:\/\/www.kaarne.fi\/superstore\/monthly-reports-data-checks\/\">Make the Imported Detail Worth Summarising<\/a> guide and the related practical questions below.<\/p>\n<ul>\n<li><a href=\"https:\/\/www.kaarne.fi\/superstore\/articles\/excel-import-leading-zero-identifiers\/\">Where Did the Zeros Go? When an Identifier Starts Looking Like a Number<\/a><\/li>\n<li><a href=\"https:\/\/www.kaarne.fi\/superstore\/articles\/monthly-report-reconciliation-beyond-total\/\">The Total Matches. Why Are Some Orders Still Missing?<\/a><\/li>\n<\/ul>\n<p>If you want a written practice route, review the <a href=\"https:\/\/www.kaarne.fi\/superstore\/excel-monthly-reports-with-matze\/\">Excel Monthly Reports with Matze course overview<\/a>. It requires compatible Excel Desktop for Windows with Power Query; you build the report yourself.<\/p>\n<p><a href=\"https:\/\/einfachmitmatze.de\/excel-monthly-reports\/#aff=pasi5e9a&amp;cam=superstore-launch-20261117\" rel=\"sponsored noopener\" target=\"_blank\">Check the course contents and current price<\/a>. <small>Affiliate link: Superstore may earn a commission if you buy. Check current contents, requirements and terms before purchasing.<\/small><\/p>\n<p><small>Technical reference: <a href=\"https:\/\/learn.microsoft.com\/en-us\/power-query\/merge-queries-overview\" target=\"_blank\" rel=\"noopener\">Microsoft: Merge queries overview<\/a>. Checked 17 November 2026. The fictional business exercise and reporting recommendations above are Superstore editorial guidance.<\/small><\/p>\n","protected":false},"excerpt":{"rendered":"<p>After a Power Query join, check the intended relationship, row counts and recognisable records before interpreting a larger total as business growth.<\/p>\n","protected":false},"author":1,"featured_media":1709,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_hide_featured_image":false,"_jetpack_featured_image_duplicate_dismissed":0,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_post_was_ever_published":false},"categories":[35],"tags":[],"class_list":["post-1662","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-ai-digital-tools"],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"https:\/\/www.kaarne.fi\/superstore\/wp-content\/uploads\/sites\/7\/2026\/11\/excel-monthly-4.webp","_links":{"self":[{"href":"https:\/\/www.kaarne.fi\/superstore\/wp-json\/wp\/v2\/posts\/1662","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.kaarne.fi\/superstore\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.kaarne.fi\/superstore\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.kaarne.fi\/superstore\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.kaarne.fi\/superstore\/wp-json\/wp\/v2\/comments?post=1662"}],"version-history":[{"count":8,"href":"https:\/\/www.kaarne.fi\/superstore\/wp-json\/wp\/v2\/posts\/1662\/revisions"}],"predecessor-version":[{"id":1774,"href":"https:\/\/www.kaarne.fi\/superstore\/wp-json\/wp\/v2\/posts\/1662\/revisions\/1774"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.kaarne.fi\/superstore\/wp-json\/wp\/v2\/media\/1709"}],"wp:attachment":[{"href":"https:\/\/www.kaarne.fi\/superstore\/wp-json\/wp\/v2\/media?parent=1662"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.kaarne.fi\/superstore\/wp-json\/wp\/v2\/categories?post=1662"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.kaarne.fi\/superstore\/wp-json\/wp\/v2\/tags?post=1662"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}