Last seen: Jul 7, 2026
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...
No file was attached. Please try again and don't forget to press "Start upload" and wait for it to finish before you submit your reply.
I couldn't test the formula as I received a #CONNECT! error, but I believe you want to sort a transposed list by dates in columns in descending order....
The screenshot didn't come through. Save it to your computer first, then upload it as an attachment and press 'start upload', wait until it's finished...
Oh, but that makes it much more complicated with pictures, that is. I wish you hadn't simplified your example so much. Since you rarely get the correc...