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

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