This is not a problem, per se, however I'm lost and I'm a not a coder so, any insight would be helpful.
I have a SharePoint list that I connected in Excel and used PowerQuery to transform the data. I have about 6 queries filtering data and one of them, just one, has a column that does not exist inthe SharePoint list (source data) or anywhere else. I looked through all 54 SharePoint columns and not one of them is 'DateCompleted', but is shows up in this one query. Here's my original post. It's not a problem because it is a column I wanted in the first place; However, I had to create a column for each query, (so 6 times) becuase this column was not available, so I'm like who created this?!?
1. I tried creating a new query to see if it shows up, and it doesn't
2. It is not a column and available, or pre-made on SharePoint.
3. The SharePoint list is a custom list, not a template.
Anyone have that happen to them, or maybe I'm not looking in the right place?