EXCEL + BLOGS
POWER BI - EXCEL 2013 BLOGS
BLOGS BY AUTHOR
BLOGS BY YEAR
Blogs from Wise Owl on PowerPivot in Power BI - Excel 2013
Showing blogs 1-4 (out of 4)
Posted by Andy Brown on 06 October 2016
It's often challenging working out how to use DAX to solve specific problems. This blog shows how to produce a pivot table showing the first and last instances of any category.
Posted by Andy Brown on 18 February 2016
PowerPivot is virtually identical to SSAS Tabular underneatht the glossy exterior, but it has got a few extra features explained in this blog (which also shows how to import PowerPivot data models into Analysis Services, and why you might want to do this).
Posted by Andy Brown on 01 April 2015
When you've created a Power Query in Excel, you can close it and load the resultant data. But how do you then change how the query loads? This blog explains how!