Forum Discussion

ESemba22's avatar
ESemba22
Frequent Visitor
2 years ago

Custom Columns In Appends

I have a file that is appending 6 differen files with sales numbers where most of the files come with a "Week Ending" colum that will stack when I append each source to each other.  The other 2 have customer specific week counts/formats that I have to use a customn column to bring in the proper date formatting to be consistent with the others. However, when I append the data tables together, the "Week Ending" colun populates blank. How do I fix this? File saved at link below

https://we.tl/t-qczffKbT3m

Need Help

2 Replies

Replies have been turned off for this discussion
  • JoeBarry's avatar
    JoeBarry
    Solution Sage
    2 years ago

    Hi ESemba22 

     

    Check the column name and format are correct, any slight difference and it will create another column. Troubleshoot by checking that all columns match in name and format

     

    Thanks

    Joe

     

    If this post helps, then please Accept it as the solution

    • ESemba22's avatar
      ESemba22
      Frequent Visitor
      2 years ago

      I wasn't very detailed in the description of my issue. My problem is that I have a couple data sources that only have "Year Week" or "WM Week" as a column when the data is brought into PBI.

       

      The "Week Ending" columns are added after the data is brough into PBI using RELATED functions.

       

      I have made sure each column header is the same but assume that there is some sort of order of operations that the append occurs before the RELATED calculations and therefore doesn't get included in the append.  Likely just a total misunderstanding of how these things work as I'm still a newbie.

       

      Thank you!