Last seen: Jun 2, 2025
Possible? Yes. But why? Without having seen your file I would say that it's best to keep all in one structured table and then create summaries per ...
The attached file contains a workaround as I believe you can't just tweak the technique used in the original file. I've kept the data from Mynda's ...
Have a look at this blog post. It explains how to combine multiple worksheets in on eworkbook.
I believe I found the data set you referred to on a UK Government site and extracted a bit of data that seems to relate to the 646,171 scores you ment...
The Year and Month are 'calculated' towards the end of the Data query in the Power Query section of the template. It extracts the year and month nu...
That shouldn't be a problem for dates where the day number is 13 or greater. Both 14/01/1995 and 01/14/1995 clearly recognised as UK and US formats. B...
Thanks for the files. Any particular reason why there is one entry separated from the other records in the GMI file (row 166 that is)? If this is a...
Not sure why this discussion is side-tracking from your real Power Query issue. The "Expression.Error: The column of region/school was not found" mess...
I understand you have added data for November and December to the Transactions table, but it doesn't show in the charts on the Report tab. Did you do ...
The screenshots that you attached are rather small and difficult to read. Could you instead upload the xlsx files (old and new). Just make sure you re...
Obviously, I cannot speak for Mynda and what her intentions were when not mentioning the Savings page in the video, but when you select cell A1 in the...
When you select "Combine & Transform", PQ generates a number of queries for you. They are listed in the left hand side of the editor and could lik...
No need to repeat your initial question. I just don't understand what's needed. Did you look at the file I uploaded? Does a pivot table do what you wa...
Thanks for the file. That clarifies the issue. The trick is that you need to include the Date initially in order to be able to sort on it, but then yo...
Thanks for the files, but I'm not sure that I understand what you want. Perhaps a pivot table with a time-line that allows you to set the start and en...