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

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

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

        Dear Danexitan,

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