In the attached power query file, I'm having an issue editing the 'Final Result' query. I want to change the name of the 'NCRs' column to 'Sales' but that changes the order of the columns and makes that column the last column.
Also, I'm wanting to add an hour to the values in the Last Knock Time column.
Any assistance would be greatly appreciated
Cannot open the Final Result Query to look at your steps. It appears that the query is not in the file but linked to the spreadsheet on your PC and generates an error message it cannot find the file.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
The query is linked to the spreadsheet in the source data folder from the zip file I uploaded
Here is a picture of what I get when I try to open your query.
Capture.JPG
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks