Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Merge Two Tables Creating Unique Table With No Duplicates

I am wanting to take two tables and create a new table that looks like the attached power bi file example.    My desired new table will match every lease number with every station available.    S...
Need Help
  • v-cazheng-msft's avatar
    v-cazheng-msft
    5 years ago

    Hi, Anonymous 

    You can use CROSSJOIN  function to create a Calculated table to get the result you want. 

     

    Table = CROSSJOIN(Lease,Station)

     

    The result looks like this:

     

     

    Best Regards,

    Caiyun Zheng

     

    Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

v-cazheng-msft's avatar
v-cazheng-msft
Community Support
5 years ago

Hi, Anonymous 

You can use CROSSJOIN  function to create a Calculated table to get the result you want. 

 

Table = CROSSJOIN(Lease,Station)

 

The result looks like this:

 

 

Best Regards,

Caiyun Zheng

 

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.