Forum Discussion
Adding Data Points to a Table or Chart After Power Query Refresh
I have an Excel workbook that has a worksheet for calculating who doesn't have access to our system based on content on the site. These calculations use XLOOKUP to compare two other workbooks (1 CSV ...
Assume you have initial query which returns blue table and loads into the grid. Let name it Result.
Query returned table from the grid, name it Result Old. Be sure it's Connection only.
Duplicate Result query, rename it as Result New, connection only as well.
Now substitute M-Code for result on
let
Source = #"Result Old" & #"Result New"
in
SourceThat's all. Now data in the table in grid will be kept as it is, on each refresh new data will be appended to that table.
Good morning. I was able to follow the above. I created the table as a query, replaced the dummy values in the table with Excel equations to calculate everything, and updated the column titles. I followed your instructions but am not sure how to add the refresh date and calculate everything onto a new row.
