Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Append reference table

Hi Everybody!

 

I have an issue while trying to append a table and a reference of itself in power bi. It seems that it's not possible.

I've got:

 

Table 1

Table 1 (reference) with some replaced values

 

I would like to append the Table 1 (reference) to the Table 1 and it seems that I can't, because I have no option to choose "Table 1 (reference) the table to append to Table 1.

 

Someone is able to help???!!

 

Many thanks!!!!!!

3 Replies

  • Nathaniel_C's avatar
    Nathaniel_C
    Community Champion

    Hi Anonymous 
    I have a reference table created in Power Query, when I click on Append, I have both tables showing. Which table I choose will be appended to the table that is already in the window. It does seem to work. Click on the drop down arrow.


    Let me know if you have any questions.

    If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos πŸ‘are nice too.
    Nathaniel

     

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi Nathaniel,

       

      Thanks for your answer! The problem is that the direction of the reference is the opposite. Is like a cyclic reference... 

      • Nathaniel_C's avatar
        Nathaniel_C
        Community Champion

        Hi Anonymous 
        Not sure what you mean by the direction of the reference?