Back in August, I wrote up a Wish List for Excel 2015. There is a new version of Excel out, and it is still the year 2015… who could have known they would call it Excel 2016!? Anyway, let’s look at some of the winners and losers… Winners: Built in Calendar support: As long as you have at least 1 date column, you now get an option to magically create a date table! Excel will guess a reasonable date range, or let you manually set the range. They Continue Reading
DAX Studio
The blog has been a bit stagnant… even though I have quite a backlog of things to share. In my defense, I did create over 900 measures in a single Power Pivot model for a customer since we last talked. Though… that idea sounds so crazy I probably shouldn’t bring it up. There has been a ton of changes in the Power BI landscape… I’m skipping that discussion. I have two different “Part 1” posts… without completing the corresponding Part 2. I’m skipping those, Continue Reading
My RSS Feed
Here is my current list of Power BI related blogs. Let me know if I missed anything awesome :) Title URL Power Query Training http://www.powerquery.training/portfolio/feed/ Sam Vanga http://samuelvanga.com/feed/ Paul Turley's SQL Server BI Blog https://sqlserverbiblog.wordpress.com/feed/ PowerPivotPro http://www.powerpivotpro.com/feed/ SQLBI http://www.sqlbi.com/feed/ Chris Webb's BI Blog https://cwebbbi.wordpress.com/feed/ Kasper de Jonge PowerPivot and Power BI Continue Reading
Financial Statements in Power Pivot
My buddy Derek Rickard gave this great talk awhile back at a local “Modern Excel User Group” meetup. I’m putting it here because a) it is awesome and b) I can never find it. Now I can! Definitely worth a watch – some really clean modeling here. Stolen without permission, because I am a bad man. Derek does some Power Pivot consulting, if you need to get ahold of him let me know, and I will get you in touch. If he gets back to me with a link to a website or something, I will add it here Continue Reading