Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Join a calculated table with an 'original' table

Hi all,    I am trying to combine a calculated table with an 'original' table.    Table A holds transactions per row. Each transaction is to be allocated to multiple customers the breakdown of sh...
Need Help
  • v-xicai's avatar
    v-xicai
    6 years ago

    Hi Anonymous ,

     

    Because Table B is a calculated table, and it won't be displayed in Query Editor, so you might not use the Merge feature to combine the two tables into one.

     

    As a workaround, you can create relationship between the two tables on field [CLIENT GROUP], then put all the desired fields into the same table visual.

     

    Or you may include the Table A in the formula which created the calculated Table B.

     

    Best Regards,

    Amy

     

    Community Support Team _ Amy

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

mwegener's avatar
mwegener
Icon for Most Valuable Professional rankMost Valuable Professional
6 years ago

Hi Anonymous,

 

please use Power Query for these kinds of transformations. 

 

If I answered your question, please mark my post as solution, this will also help others.

Please give Kudos for support.