Forum Discussion

Sushmitha1's avatar
Sushmitha1
New Member
3 years ago

PBI

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.

2 Replies

  • AnthonyGenovese's avatar
    AnthonyGenovese
    Icon for Resolver III rankResolver III
    3 years ago

    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's avatar
      Sushmitha1
      New Member
      3 years ago

      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)