PBI

[Sushmitha1]

I have two existing tables without any relationship between two tables, I need to create a new table by using two columns from those two existing tables in PowerBI.

can anyone tell me the approach or DAX queey to be used.

[AnthonyGenovese]

Can you provide an example of the data in the two tables, and how you want the new table to look like?

I am guessing I would want to do this in Power Query and not Dax, but we will see once you answer the above.

If this post was helpful, please kudos or accept the answer as a solution.
~ Anthony Genovese
Need more PBI help? PM me for affordable, dedicated training or consultant recomendations!

[Sushmitha1]

For example,I have many columns in both the tables but I need only two columns from both the tables Domestic (Table 1)I would need Product-Name(Calculated column),Count(measure) and International (Table 2) Product-Name Int(Calculated column),Count-Int(Measure)