Power BI Pro Tip: making date / time calculations work (Time Intelligence)
Ever so often I get asked how to do a year-over-year, quarter-over-quarter, month-over-month or year-vs-year calculation in Power BI. In most cases people would like to create a KPI to measure a certain periods performance compared to…
Version compatibility between Power Pivot Data Models in Excel 2010 / 2013 and SharePoint 2010 / 2013
I have been getting a lot of questions on compatibility around Excel 2010 / Excel 2013 / SharePoint 2010 / SharePoint 2013. To be honest, I have been confused myself. I encourage you to check out our Excel…
Power BI and why you should care
Yesterday Microsoft announced Power BI for Office 365: a self-service Business Intelligence solution delivered through Excel and Office 365. Power BI ties together the various bits and pieces we already had (Power View, PowerPivot, GeoFlow, Data Explorer) and…