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.

6 Replies

  • 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.