I haven’t been looking at this site for a while (multiple years). I am now retired from Microsoft.

If you’re curious what I’m up to in retirement, I have started a new blog over at rpihlgrenblog.wordpress.com

Thanks for all the fish!

All too often companies respond to business needs by shopping for “proven” solutions, repeatable processes to achieve a desired outcome. They call these “best practices,” which for many translates into Don’t tell me why something worked, tell me how they did it. Rote, universal solutions exhibit little respect for the individuality of a problem, and epitomize lazy management. Their adoption often spawns professional organizations which certify legions of consultants selling one-size-fits-all processes. The end result is that good initial ideas become codified and ineffective industry dogma.

Barry, Tonianne DeMaria; Jim Benson (2011-01-03). Personal Kanban: Mapping Work | Navigating Life (Kindle Locations 318-322). Modus Cooperandi Press. Kindle Edition.

Earlier this month I left Microsoft to move back to the Midwest (family reasons). We are still going through the transition – we’re not there quite yet – but I’m starting to think about what’s next.

For starters, we have some stuff to do related to the reason why we are moving. I expect that will take a few months. Then we’ll probably take some time to relax, assess our situation, and consider the future. Right now we don’t have any specific plans.

I may blog more during this time of transition and reflection, or not. My head probably won’t be in the same space it’s been for the past few years. So, we’ll see. It feels a little bit weird…

I’ve heard a number of requests for the ability to reorder Power View sheet tabs in Excel 2013. While this is currently a bug that will be fixed in the future, there is a work-around to do this now.

Assuming you have a workbook that contains a number of Power View sheets and you want to move the last one you created (“Power View4” in the screenshot here) to be the leftmost tab in the workbook.


First, click on the plus sign to create a new Excel sheet.


Move that sheet to be next to the Power View sheet you want to move. With the new Excel sheet selected, hold down the control key and click on the Power View sheet you want to move so that both tabs are selected.


Now, click and drag the Excel sheet to the desired location. The Power View sheet will come along for the ride.


When the Power View sheet is in the desired location you can select and delete the new Excel sheet that you created.


Did you know that you can write DAX queries against tables in your workbook’s data model in Excel 2013? You can, although I didn’t know you could until yesterday. I’m surprised I didn’t learn about this until now, This comes in real handy when experimenting with DAX. Here’s how to do it:

1. Import some data into a workbook data model

2. Create a new sheet

3. In the data tab of the ribbon click on Existing Connections and in the Existing Connections dialog, select the Tables tab:



4. Select the table you want to query and click the Open button

5. In the Import Data dialog, select Table and click OK:



6. You now have a table in the worksheet that contains the contents of the table from the data model. To change that table into the result of a DAX query on your data model, right click on any cell in the table and select Table \ Edit DAX:



7. In the Edit DAX dialog, change the Command Type dropdown from Table to DAX and enter your DAX query:



8.The table now changes to the result of your DAX query. Pretty cool!