Forum Discussion
Helper IIAmount duplicated after appending query
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.
Helper IIDear Danextian,
Thanks for your reply , Could you please explain how to get this custom column , what is the dax measue to be added?
Thanks
Super UserHi 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