Join two Summarized Tables

[Anonymous]

I created two summarized tables from two different queries. I then created colums ID(Table 1) and Id3(Table 2) to create a relationship between the two tables. The resulting relationship is a many-to-on (Table 2 to Table 1). I would like to combine these two tables and keep all the columns from both tables. I tried creating another summarized table from the two but it does not keep the excess rows from Table 1. Please assist.

Table 1Table 2

[amitchandak · Accepted solution]

@Anonymous for join you have crossjoin and naturalinnerjoin

refer

https://www.sqlbi.com/articles/from-sql-to-dax-joining-tables/

https://docs.microsoft.com/en-us/dax/naturalinnerjoin-function-dax

You can also try Union

[Anonymous]

Thanks a lot for the documentation. I used the NaturalLeftOuterJoin function and it works well.