Updating millions of rows
In this way, you don’t have to open the Power Pivot window to modify the Data Model since the Year would already be part of the source data.
Once the Data Model is ready, you can create the Pivot Table by clicking on the Pivot Table button on the Home Tab of the Power Pivot Window.
Then wait a couple days and chase it with it’s charming cousin, Optimizing Your Query Plans with the SQL Server 2014 Cardinality Estimator. ⇒ If you’re too proactive, you’ll eventually be sorry: If you set up statistics maintenance too aggressively, your maintenance windows can start to run long.
I’m also not talking about statistics for memory optimized tables in this article. Back when I read philosophy, I found Aristotle a bit annoying because he talked so much about “moderation”. You shouldn’t run statistics maintenance against a database at the same time you’re checking for corruption, rebuilding indexes, or running other IO intensive processes.
Click on any cell of within the Pivot Table and go to Insert Pivot Chart.
To add a column, go to the rightmost column and double-click the header, then type the desired name.
Then on the first row of the new column type the formula ‘=YEAR([Date])’ and press enter. Important: Another way of adding the Year column is to do it in Power Query.
If you want to follow along, please download the files from this link.
If you don’t have Power Query on your computer, you can download it from here: Power Query Download.