Column not populating

Anonymous Hello Nate,

Thank you on the response. The spend column does exist. Infact most of the viz use that field and now it draws a blank for those 4 months. There are no extra columns it has been the same way since the first upload 5 columns and that's how the code reads [Columns = 5] and then one custom column(month end date). They are all formatted to general on all the files. Yet, just for those 4 months it keeps drawing in a null.

I even tried on a new PBI file to import the csv (4 months) and it works (spend column). I just don't know why it shows up null when appended all together with past data on the original file.

The only inconsistency i see on all the raw data extracts is sometimes the number comes in as whole number, decimal and some negative.