Custom Columns In Appends

[ESemba22]

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

[JoeBarry]

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]

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!