to hQuote of the Day
The best way to predict the future is to create it.
— Abraham Lincoln
I heard a news commentator say that the US defense budget is larger than the combined defense budgets for the next ten largest spenders. I thought that this would be easy to check and would provide my staff a beginner's example to use for their Excel self-training.
I was able to find the list of the top fifteen countries with respect to defense spending in 2015 on the Wikipedia. I used Power Query to grab the data, clean it up, and generate a running total – Figure 1 is my final result. The particular skill I wanted to illustrate with this exercise was how to generate a running total in Power Query.
Yes, the US defense budget is larger than the next ten largest defense budgets combined. My source file is here for those who wish to follow my work.