Forum Discussion

hanyfouda2023's avatar
hanyfouda2023
Icon for Helper II rankHelper II
3 years ago
Solved

Amount duplicated after appending query

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   
Need Help
  • danextian's avatar
    danextian
    3 years ago

    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.

danextian's avatar
danextian
Icon for Super User rankSuper User
3 years ago

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's avatar
hanyfouda2023
Icon for Helper II rankHelper II
3 years ago

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