Amount duplicated after appending query

[hanyfouda2023]

Dears,

I'm facing an issue that I appended 7 tables but when I check the data I found that amount duplicated without any reason although source file amounts aren't duplicated

Thanks 

[danextian · Accepted solution]

Hii @hanyfouda2023 ,

You might have appened the same table several times. I'd usually add a custom column named Source which value is anything that describes the sourc to each table that I append so I'd know where my numbers are coming from. This practice makes it easy to troubleshoot for errors.

[hanyfouda2023]

Dear Danextian,

Thanks for your reply , Could you please explain how to get this custom column , what is the dax measue to be added?

Thanks

[danextian]

Hi @hanyfouda2023 ,

It is a custom column in the query editor. In Add Column tab, go to custom column and create a Source column that indicates the source of your data. Do this for all the seven tables. Make sure to use the same column name for all of them.

[hanyfouda2023]

Dear Danexitan,

Thanks I added the columns , and found which amount arent right. Do you have any idea how to solve it

[danextian]

Ì am not sure. Questions are:

Why are the amounts not right?

Did you append the several times?

What makes them being duplicated?

[hanyfouda2023]

Why are the amounts not right? Yes its duplicated 

Did you append the several times? Yes 

What makes them being duplicated? I need to know why figuers not accurate