Power Query Inner JOIN Merge not working as expected

[charris1119]

Greetings,

I am using Power BI Desktop for Report Server, May 2022 version. I am getting unexpected results when performing a Merge of two tables using an Inner Join. Below are the tables and results.

Table 1 (RCM Room Activity Patient Types) :

NOTE: There are a LOT more rows in the actual table. I just limited to these rows as they illustrate the issue.

Table 2 (Note Categories by Patient Type):

Results:

The M code for the step is as follows:

I am not understanding why rows with Patient Types 'P' and '3' are being filtered out; I see why Patient Type 'A' is filtered out. Is there something I am missing, or is this a bug, or some sort of weird side-effect, or...? Any help or insight is appreciated. Thanks in advance.

[charris1119]

Additional Info:

The same issue occurs using a Left Outer Join:

[charris1119 · Accepted solution]

UPDATE:

I figured it out. There were extra spaces in the Pt Type column of Table 2.

I feel sufficiently foolish. ☹️