join 2 different tables

Hi jppuam 

Full outer will merge rows from both TableA and Table B (matching or not matching).

For example: 

Table A has dates 2021/01/01 - 2021/01/03.

Table B has date 2021/01/04.

If you use Full outer to merge two tables, result is as below.

Here is a blog about join kind in Merge in Power Query.

For reference: Choose the Right Merge Join Type in Power BI

If you want to expand all values in Table B for each Row in Table A, you can try to add custom column.

Expand rows you need from Table B.

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.