Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Data doubling after Append the 2 tables to one table

Hi,

When we append the 2 queries in power query editor in power bi, data is getting double and values shown as negative.

 

Please advise me.

 

Regards,

Srinivas.

 

Tips and Tricks

2 Replies

  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    Icon for Most Valuable Professional rankMost Valuable Professional
    4 years ago

    Please paste some sample data from both queries as well as sample output pointing out the problem in output.

  • v-jingzhang's avatar
    v-jingzhang
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi Anonymous 

     

    How did you append 2 tables? What do the tables look like before appending and after appending? Can you please show some data or screenshot (removing sensitive data) to show the problem? 

     

    Is it possible that there are duplicated data in both tables? 

     

    Best Regards,
    Community Support Team _ Jing