Thanks, very insightful. If the comparison in the last example was continually rolling forward. How would you compare January against December etc.? As the calculation is subtracting 1 to go back to previous month and this would break past 12. Possibly some sort of incrementing index number column. I'd be interested to know. But please keep your amazing videos coming. Love it.
You're welcome, glad you're enjoying the videos! Yes it would include an index column, but you would create the query a bit differently to what I've shown in the video. In the video the two index columns are used to merge the two tables. In the solution for comparing January to December, you're correct, index would be used as the incrementing index number to subtract the current row from the previous row. This would be done in a Custom Column. I will provide the solution in upcoming newsletters, please be sure to subscribe so you can get the practice file and solution once it's released: thequeryeditor.beehiiv.com/subscribe
thank you for your effort in making this video . l will need more time to understand and follow the last example
You’re most welcome, glad you’re enjoying the videos 😊
Excellent, each step is straightforward yet the end-result is impressive. Thanx!
Thank you Jerome, glad you liked it!
great video! thanks for sharing
Thanks for watching!
Thanks
Thank you for all your support! I really appreciate it 😊😊
Thanks, very insightful. If the comparison in the last example was continually rolling forward. How would you compare January against December etc.? As the calculation is subtracting 1 to go back to previous month and this would break past 12. Possibly some sort of incrementing index number column. I'd be interested to know. But please keep your amazing videos coming. Love it.
You're welcome, glad you're enjoying the videos! Yes it would include an index column, but you would create the query a bit differently to what I've shown in the video. In the video the two index columns are used to merge the two tables. In the solution for comparing January to December, you're correct, index would be used as the incrementing index number to subtract the current row from the previous row. This would be done in a Custom Column. I will provide the solution in upcoming newsletters, please be sure to subscribe so you can get the practice file and solution once it's released: thequeryeditor.beehiiv.com/subscribe
how to add that refresh button in excel??🤔
Please check out this video here: ua-cam.com/video/aa0EDero41c/v-deo.htmlsi=_6R8a5O_s3bi4hoy hope it helps :)
@@MissMicrosoft thank you 👍
You’re welcome!
Speak slowly please