Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Join 2 rows from tables

Hi, i have 2 tables, both has DATAAREAID and JOURNALID. I want to join these 2 rows, how can i do that?     Have i to create a compound key? There are other ways?   Thanks
Need Help
  • itchyeyeballs's avatar
    itchyeyeballs
    7 years ago

    yes, you will have to create a compound key by creating new columns that combine the fields you want to join on.

     

    You could potentially create a seperate lookup table with all the distinct values and corresponding index fields but it's probably only worth it if you have lots of records and/or your compound fields are very long

v-piga-msft's avatar
v-piga-msft
Resident Rockstar
7 years ago

Hi Anonymous ,

I have a little confused about your requirement.

What is the " join two rows"? Normally, we could join tables in power bi.

If it is convenient, could you share the data sample which could reproduce your scenario and your desired output so that we could help further on it?

Best Regards,

Cherry

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Sorry,

i mean thath i want to join 2 table with 2 keys.

 

Have to create a compound key? No other ways?

 

Thanks

  • v-piga-msft's avatar
    v-piga-msft
    Resident Rockstar
    7 years ago

    Hi Anonymous ,

    Normally, we could join multiple tables with UNION function in Power BI.

    If you still need help, please share your data sampl and your desired output so that we could help further on it.

    Best  Regards,

    Cherry

     

  • itchyeyeballs's avatar
    itchyeyeballs
    Impactful Individual
    7 years ago

    yes, you will have to create a compound key by creating new columns that combine the fields you want to join on.

     

    You could potentially create a seperate lookup table with all the distinct values and corresponding index fields but it's probably only worth it if you have lots of records and/or your compound fields are very long